Re: How can I merge two tables? - Mailing list pgsql-general

From Diego Augusto Molina
Subject Re: How can I merge two tables?
Date
Msg-id CAGOxLdHJJPgxJFYg6AaAhi=rRRSG-tjL8fEJx5tRjm-r20vT3g@mail.gmail.com
Whole thread Raw
In response to How can I merge two tables?  (Jerry LeVan <jerry.levan@gmail.com>)
List pgsql-general
Mmm... maybe if you can dump them as inserts you'll be able to restore
them in one DB only. Important: make the restore connection autocommit
(i.e. don't put the --single-transaction flag). That way individual
INSERTs will fail without affecting the other data if that INSERT
violates the PK. This is slow! specially with large data sets.
Once you've got the data in one DB, you can use some replication
system if you want to have that DB in all your machines. One of that
systems is Slony-I, though I haven't tried it.

--
Diego Augusto Molina
diegoaugustomolina@gmail.com

ES: Por favor, evite adjuntar documentos de Microsoft Office. Serán
desestimados.
EN: Please, avoid attaching Microsoft Office documents. They shall be discarded.
LINK: http://www.gnu.org/philosophy/no-word-attachments.html

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Memory leak somewhere at PQconnectdb?
Next
From: Ondrej Ivanič
Date:
Subject: Re: How can I merge two tables?