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|:-( ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster