From: | Serge Fonville <serge(dot)fonville(at)gmail(dot)com> |
---|---|
To: | Intengu Technologies <sindile(dot)bidla(at)gmail(dot)com> |
Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: How do I create a new table based on combining a number of tables |
Date: | 2009-09-28 08:04:10 |
Message-ID: | 680cbe0e0909280104u67bc6d5cj8d372a370f347391@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
Both can do the job
Use a union
http://www.postgresql.org/docs/8.4/interactive/queries-union.html.
HTH
Regards,
Serge Fonville
On Mon, Sep 28, 2009 at 9:59 AM, Intengu Technologies <
sindile(dot)bidla(at)gmail(dot)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(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Intengu Technologies | 2009-09-28 10:00:37 | Re: How do I create a new table based on combining a number of tables |
Previous Message | Intengu Technologies | 2009-09-28 07:59:55 | How do I create a new table based on combining a number of tables |