MIME-Version: 1.0
References: 
 <CA+i5JwYX9jDXv2fS9u6JP24=xpaTX_r6SXMjUCg5JGwTA2cPog@mail.gmail.com>
In-Reply-To: 
 <CA+i5JwYX9jDXv2fS9u6JP24=xpaTX_r6SXMjUCg5JGwTA2cPog@mail.gmail.com>
From: Shaozhong SHI <shishaozhong@gmail.com>
Date: Fri, 14 Oct 2022 07:00:24 +0100
Message-ID: 
 <CA+i5JwaD2rz-jJdm9_SK=88z=J0SDNmij98hMZxCwLuHxbz2Mw@mail.gmail.com>
Subject: Append a list of tables to an empty table to form a whole table
To: pgsql-sql <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000032e4c405eaf85802"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2Bi5JwaD2rz-jJdm9_SK%3D88z%3DJ0SDNmij98hMZxCwLuHxbz2Mw%40mail.gmail.com>
Precedence: bulk

--00000000000032e4c405eaf85802
Content-Type: text/plain; charset="UTF-8"

How best to append a list of tables to an empty table to form a whole table?

Pseudo codes show the desirable logic.


There are a list of tables with exactly same colums
table_a
table_b
table_c

Create an empty table  emp_table

Foreach a_name in ARRAY ARRAY['table_a', 'table_b', 'table_c'] loop
   insert into em_table as select * from table a_name

end loop;

Can something like that be done is PostGIS?

Regards,

David

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

<div dir=3D"ltr"><div class=3D"gmail_quote"><br><br><div dir=3D"ltr"><div d=
ir=3D"ltr"><div dir=3D"ltr">How best to append a list of tables to an empty=
 table to form a whole table?<div><br></div><div>Pseudo codes show the desi=
rable logic.</div><div><br></div><div><br></div><div><div><br></div><div>Th=
ere are a list of tables with exactly same colums</div><div>table_a</div><d=
iv>table_b</div><div>table_c</div><div><br></div><div>Create an empty table=
=C2=A0 emp_table</div><div><br></div><div>Foreach a_name in ARRAY ARRAY[=
9;table_a&#39;, &#39;table_b&#39;, &#39;table_c&#39;] loop</div><div>=C2=A0=
 =C2=A0insert into em_table as select * from table a_name</div><div><br></d=
iv><div>end loop;</div></div><div><br></div><div>Can something like that be=
 done is PostGIS?</div><div><br></div><div>Regards,</div><div><br></div><di=
v>David</div></div></div></div>
</div></div>

--00000000000032e4c405eaf85802--