Skip site navigation (1) Skip section navigation (2)

How do I create a new table based on combining a number of tables

From: Intengu Technologies <sindile(dot)bidla(at)gmail(dot)com>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: How do I create a new table based on combining a number of tables
Date: 2009-09-28 07:59:55
Message-ID: a1afa64b0909280059g1edfc252gf0b19857274ae28b@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi List

I have a number of tables that I would want to combine (append one
table to another) into a single table. What would be the best approach
and how do I write the corresponding sql statement:

1. Create a new table

2. Create a view

-- 
Sindile Bidla

Responses

pgsql-novice by date

Next:From: Serge FonvilleDate: 2009-09-28 08:04:10
Subject: Re: How do I create a new table based on combining a number of tables
Previous:From: Nicholas SlaboszDate: 2009-09-28 06:45:56
Subject: get current function name

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group