Postgres Pro
Downloads
Home   >   mailing lists

Re: how to merge two databases - Mailing list pgsql-admin

From Jyry Kuukkanen
Subject Re: how to merge two databases
Date
Msg-id Pine.LNX.4.58L.0511101155230.30311@cyclone.neutech.fi
Whole thread Raw
In response to how to merge two databases  (murali segu <segu_mk@yahoo.co.uk>)
List pgsql-admin
Tree view 
Hello

On Thu, 10 Nov 2005, murali segu wrote:

> i want to merge two databases how it is done plz help me
> thanQ


This should do the trick (under U*ix shell):

pg_dump -U username -h hostname source_db | psql -U username -h hostname target_db



--
--Jyry
C|:-(    C|:-/    C|========8-O    C|8-/    C|:-(

pgsql-admin by date:

Previous
From: "sandhya"
Date:
Subject: hi...
Next
From: Scott Marlowe
Date:
Subject: Re: autovacuum daemon question...