Postgres Pro
Downloads
Home   >   mailing lists

Re: Can we generate a series of tables in a loop and then use another loop to union all? - Mailing list pgsql-sql

From Frank Gard
Subject Re: Can we generate a series of tables in a loop and then use another loop to union all?
Date
Msg-id e0288eb1-5d3e-266a-6d1f-a4468786c53e@familie-gard.de
Whole thread Raw
In response to Can we generate a series of tables in a loop and then use another loop to union all?  (Shaozhong SHI <shishaozhong@gmail.com>)
List pgsql-sql
Tree view

Hi,

you can use PL/pgSQL's "EXECUTE" to do such things.

Cheers,
Frank.

Am 13.10.22 um 17:44 schrieb Shaozhong SHI:
Can we do the following?

for j in 1..max loop
create table j as select .............
end loop;

Then,  We do 


Alternatively, can we generate an empty table and append each newly generated table to it so that we end up with a whole table?

Regards,

David

pgsql-sql by date:

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