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

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