How to move data from 1 database to another?

From: "Thomas LeBlanc" <thomasatiem(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to move data from 1 database to another?
Date: 2004-05-11 15:54:00
Message-ID: BAY17-F4HWyGLt82Jju00035ab7@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have 2 databases. I want to move data from table table1 in database db1 to
table2 in db2.

When I query 1 table from another database, I get a cross-database
references are not implemented.

server1% psql db1
emdata=# select * from db2.public.table1;
ERROR: Cross-database references are not implemented

What can I do to get the data into another database?

Thanks,
Thomas

_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar get it now!
http://toolbar.msn.com/go/onm00200415ave/direct/01/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message btober 2004-05-11 15:59:21 Re: Data Encryption in PostgreSQL, and a Tutorial.
Previous Message Michal Hlavac 2004-05-11 15:41:54 Re: Data Encryption in PostgreSQL, and a Tutorial.