Postgres Pro
Downloads
Home   >   mailing lists

How to merge 3 databases in one database quickly - Mailing list pgsql-general

From Nagib Abi Fadel
Subject How to merge 3 databases in one database quickly
Date
Msg-id 20030604075200.74149.qmail@web21412.mail.yahoo.com
Whole thread Raw
Responses Re: How to merge 3 databases in one database quickly  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Re: How to merge 3 databases in one database quickly  (Peter Eisentraut <peter_e@gmx.net>)
Re: How to merge 3 databases in one database quickly  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Re: How to merge 3 databases in one database quickly  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
Tree view
I'm trying to merge 3 databases in one database using pg_dump.
 
pg_dump db1 > database.txt
pg_dump db2 >> database.txt
pg_dump db3 >> database.txt
 
then i restore:
psql database < database.txt
 
I  had errors when trying to restore, i fixed some of them but still i get other kinds of error.
What i want to know is : IS THERE ANY OTHER WAY TO MERGE THE 3 DATABASES QUICKLY WITHOUT GETTTING ERRORS ???
 
thx
 
 

Do you Yahoo!?
Free online calendar with sync to Outlook(TM).

pgsql-general by date:

Previous
From: "shreedhar"
Date:
Subject: What is this problem with http://gborg.postgresql.org/
Next
From: "Ing. Roberto Andrade Fonseca"
Date:
Subject: Re: Create Foriegn Key