public inbox for [email protected]
help / color / mirror / Atom feedFrom: Frank Gard <[email protected]>
To: [email protected]
Subject: Re: Append a list of tables to an empty table to form a whole table
Date: Fri, 14 Oct 2022 10:50:06 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <CA+i5JwYX9jDXv2fS9u6JP24=xpaTX_r6SXMjUCg5JGwTA2cPog@mail.gmail.com>
<CA+i5JwaD2rz-jJdm9_SK=88z=J0SDNmij98hMZxCwLuHxbz2Mw@mail.gmail.com>
<[email protected]>
Sorry,
c&p-error (was in hurry this morning). Omit "as" and "table", please:
EXECUTE 'insert into em_table select * from ' || a_name;
Frank.
Am 14.10.22 um 09:13 schrieb Frank Gard:
>
> 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:[email protected]
>
> 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
--
Vielen Dank und viele Grüße,
Frank Gard
Zum Brünnchen 27
D-66583 Spiesen-Elversberg
Tel. : +49(6821)790880
E-Mail:[email protected]
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
view thread (3+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Append a list of tables to an empty table to form a whole table
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox