Postgres Pro
Downloads
Home   >   mailing lists

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

From Thomas Güttler
Subject Re: [GENERAL] Move rows from one database to other
Date
Msg-id edf4201c-7d0d-fba6-416b-125511c40b73@thomas-guettler.de
Whole thread Raw
In response to Re: [GENERAL] Move rows from one database to other  (Francisco Olarte <folarte@peoplecall.com>)
Responses Re: [GENERAL] Move rows from one database to other  (Francisco Olarte <folarte@peoplecall.com>)
List pgsql-general
Tree view 

Am 23.02.2017 um 10:33 schrieb Francisco Olarte:
> Thomas:
>
> On Wed, Feb 22, 2017 at 1:51 PM, Thomas Güttler
> <guettliml@thomas-guettler.de> wrote:
>> I want to **move** the data. The data should get deleted on the satellite
>> after transfer.
>> I don't know how to delete the data which was copied, since inserts can
>> happen during the copy statement.



> Depending on the structure / control / kind of ops you have on the
> satellite you can try a two-table trick, similar to a common one used
> to process files in spool directories.
 > [cut]

This sound good. Is there a name for this trick, to find more details?

Regards,
   Thomas


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

pgsql-general by date:

Previous
From: Benoit Lobréau
Date:
Subject: Re: [GENERAL] NOTIFY command impact
Next
From: Thomas Güttler
Date:
Subject: Re: [GENERAL] Move rows from one database to other