Re: Can we generate a series of tables in a loop and then use another loop to union all?

Hi,

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

Cheers,
Frank.

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