Postgres Pro
Downloads
Home   >   mailing lists

Re: How do I create a new table based on combining a number of tables - Mailing list pgsql-novice

From Serge Fonville
Subject Re: How do I create a new table based on combining a number of tables
Date
Msg-id 680cbe0e0909280104u67bc6d5cj8d372a370f347391@mail.gmail.com
Whole thread Raw
In response to How do I create a new table based on combining a number of tables  (Intengu Technologies <sindile.bidla@gmail.com>)
Responses Re: How do I create a new table based on combining a number of tables
List pgsql-novice
Tree view
Hi,

Both can do the job

Use a union

HTH

Regards,

Serge Fonville

On Mon, Sep 28, 2009 at 9:59 AM, Intengu Technologies <sindile.bidla@gmail.com> wrote:
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

--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice



--
Convince Google!!
They need to support Adsense over SSL
https://www.google.com/adsense/support/bin/answer.py?hl=en&answer=10528
http://www.google.com/support/forum/p/AdSense/thread?tid=1884bc9310d9f923&hl=en

pgsql-novice by date:

Previous
From: Intengu Technologies
Date:
Subject: How do I create a new table based on combining a number of tables
Next
From: Intengu Technologies
Date:
Subject: Re: How do I create a new table based on combining a number of tables