Postgres Pro
Downloads
Home   >   mailing lists

How to union all tables in a schema into one whole table? - Mailing list pgsql-sql

From Shaozhong SHI
Subject How to union all tables in a schema into one whole table?
Date
Msg-id CA+i5JwaHBw59OWB-c6gbu==9kOGeGxDN=eZ5QN40=RxeXR1Vjg@mail.gmail.com
Whole thread Raw
Responses Re: How to union all tables in a schema into one whole table?  (Frank Gard <frank.von.postgresql.org@familie-gard.de>)
List pgsql-sql
Tree view
A series of table like tttt.table1, ttt.table2 has been generated in the schema ttt.

How best to union all these tables into a whole one?

They have the exact same columns.

Regards,

David

pgsql-sql by date:

Previous
From: Frank Gard
Date:
Subject: Re: Can we generate a series of tables in a loop and then use another loop to union all?
Next
From: Frank Gard
Date:
Subject: Re: How to union all tables in a schema into one whole table?