Re: How do I create a new table based on combining a number of tables
| От | Serge Fonville |
|---|---|
| Тема | Re: How do I create a new table based on combining a number of tables |
| Дата | |
| Msg-id | 680cbe0e0909280104u67bc6d5cj8d372a370f347391@mail.gmail.com обсуждение исходный текст |
| Ответ на | How do I create a new table based on combining a number of tables (Intengu Technologies <sindile.bidla@gmail.com>) |
| Ответы |
Re: How do I create a new table based on combining a number
of tables
|
| Список | pgsql-novice |
Hi,
Both can do the job
Use a union
HTH
Regards,
Serge Fonville
--
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
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 по дате отправления: