How to merge 3 databases in one database quickly

From: Nagib Abi Fadel <nagib_postgres(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to merge 3 databases in one database quickly
Date: 2003-06-04 07:52:00
Message-ID: 20030604075200.74149.qmail@web21412.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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).

Responses

Browse pgsql-general by date

  From Date Subject
Next Message shreedhar 2003-06-04 11:54:40 What is this problem with http://gborg.postgresql.org/
Previous Message Verhaag, G. 2003-06-04 07:46:30 ERROR: CreateTrigger: function... (concluded)!