gt; I'd recommend using the following:
>
> CREATE TABLE b AS ( SELECT * FROM a );
>
> This way, you only define the columns and insert the data once, then let
> Postgres do the rest for you. Obviously if you need to have a separate table
> B ID, you can alter as necessary.
rds of 'b'.
So the question is - what to put in WHERE clause to match RETURNING with rows
being inserted from 'b'?
Thanks!
--
Aleksandr Furmanov
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
on of new features and
syntax for FTS configuration. The syntax itself is still at the
discussion stage. You can check it out at pgsql-hackers mailing list if
you are interested in[1]. Any feedback on the patch in terms of
internals, syntax, behavior or idea is welcome.
[1]
https://www.postgresql.o
