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	June 7, 2003 04:17:47
Msg-id	20030604075200.74149.qmail@web21412.mail.yahoo.com Whole thread Raw
Responses	Re: How to merge 3 databases in one database quickly Re: How to merge 3 databases in one database quickly Re: How to merge 3 databases in one database quickly Re: How to merge 3 databases in one database quickly
List	pgsql-general

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).

From: "shreedhar"
Date: 07 June 2003, 03:50:11
Subject: What is this problem with http://gborg.postgresql.org/

From: "Ing. Roberto Andrade Fonseca"
Date: 07 June 2003, 04:20:32
Subject: Re: Create Foriegn Key