Re: [GENERAL] Move rows from one database to other

>>I have other concerns: atomar transaction. Movement should happen completely or not all.
>>I don't think you can do this reliable (atomic transaction) with "copy table_name".
>
> You can if you wrap it in a transaction:

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.

Regards,
   Thomas Güttler



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