Postgres Pro
Downloads
Home   >   mailing lists

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

From Shaozhong SHI
Subject Can we generate a series of tables in a loop and then use another loop to union all?
Date
Msg-id CA+i5JwaYSOw=aAQcNH3M22VkzKBhcf9pyG4VTKG3yCe-r41Sxg@mail.gmail.com
Whole thread Raw
Responses Re: Can we generate a series of tables in a loop and then use another loop to union all?  (Frank Gard <frank.von.postgresql.org@familie-gard.de>)
List pgsql-sql
Tree view
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: Peter Hendriks
Date:
Subject: Re: Delete from locking ordering differences
Next
From: Frank Gard
Date:
Subject: Re: Can we generate a series of tables in a loop and then use another loop to union all?