Re: [GENERAL] Move rows from one database to other - Mailing list pgsql-general

Am 23.02.2017 um 13:44 schrieb Leknín Řepánek:
> Maybe you can do something like
>
> WITH cte AS (
> DELETE FROM t1 WHERE cond
> RETURNINIG *
> )
> INSERT into t2
> SELECT * FROM cte;
>
> To move rows between tables with combination with fdw_postgres and
> foreign table.


... this way you don't need the second table ... nice.


--
Thomas Guettler http://www.thomas-guettler.de/