From: | Frank Gard <frank(dot)von(dot)postgresql(dot)org(at)familie-gard(dot)de> |
---|---|
To: | pgsql-sql(at)lists(dot)postgresql(dot)org |
Subject: | Re: Append a list of tables to an empty table to form a whole table |
Date: | 2022-10-14 07:13:05 |
Message-ID: | d4468415-90b4-7560-849b-d35acc94de56@familie-gard.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi,
again: Use EXECUTE! It's well documented here: https://www.postgresql.org/docs/15/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
In your case, you can simply replace your INSERT statement by the following:
EXECUTE 'insert into em_table as select * from table ' || a_name;
Hope this helps.
Frank.
Am 14.10.22 um 08:00 schrieb Shaozhong SHI:
>
>
> 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
--
Vielen Dank und viele Grüße,
Frank Gard
Zum Brünnchen 27
D-66583 Spiesen-Elversberg
Tel. : +49(6821)790880
E-Mail:frank(at)familie-gard(dot)de
Bitte denken Sie über Ihre Verantwortung gegenüber der Umwelt nach,
bevor Sie diese Mail ausdrucken.
Bitte senden Sie mir keine Word-, Excel- oder PowerPoint-Anhänge.
Siehehttp://www.gnu.org/philosophy/no-word-attachments.de.html
GnuPG / PGP info
================
Schlüssel-ID: 0xC8C1A552
Fingerabdruck / fingerprint:
3EFD EF94 4841 38B5 DB40 95D8 C69C 71C5 C8C1 A552
From | Date | Subject | |
---|---|---|---|
Next Message | Frank Gard | 2022-10-14 08:50:06 | Re: Append a list of tables to an empty table to form a whole table |
Previous Message | Shaozhong SHI | 2022-10-14 06:00:24 | Append a list of tables to an empty table to form a whole table |