MIME-Version: 1.0
From: Shaozhong SHI <shishaozhong@gmail.com>
Date: Thu, 13 Oct 2022 16:44:39 +0100
Message-ID: 
 <CA+i5JwaYSOw=aAQcNH3M22VkzKBhcf9pyG4VTKG3yCe-r41Sxg@mail.gmail.com>
Subject: Can we generate a series of tables in a loop and then use another
 loop to union all?
To: pgsql-sql <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000c24d1505eaec63ad"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2Bi5JwaYSOw%3DaAQcNH3M22VkzKBhcf9pyG4VTKG3yCe-r41Sxg%40mail.gmail.com>
Precedence: bulk

--000000000000c24d1505eaec63ad
Content-Type: text/plain; charset="UTF-8"

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

--000000000000c24d1505eaec63ad
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">Can we do the following?<div><br></div><d=
iv><div>for j in 1..max loop</div><div><span style=3D"white-space:pre">	</s=
pan>create table j as select .............</div><div>end loop;</div></div><=
div><br></div><div>Then,=C2=A0 We do=C2=A0</div><div><br></div><div><br></d=
iv><div>Alternatively, can we generate an empty table and append each newly=
 generated table to it so that we end up with a whole table?</div><div><br>=
</div><div>Regards,</div><div><br></div><div>David</div></div></div>

--000000000000c24d1505eaec63ad--