Postgres Pro
Downloads
Home   >   mailing lists

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

From Intengu Technologies
Subject How do I create a new table based on combining a number of tables
Date
Msg-id a1afa64b0909280059g1edfc252gf0b19857274ae28b@mail.gmail.com
Whole thread Raw
Responses Re: How do I create a new table based on combining a number of tables  (Serge Fonville <serge.fonville@gmail.com>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Sergey Samokhin
Date:
Subject: Re: GRANT SELECT on all the partitions?
Next
From: Serge Fonville
Date:
Subject: Re: How do I create a new table based on combining a number of tables