Horton

Re: How to move data from 1 database to another?

Jonathan Bartlett <johnnyb@eskimo.com>

View thread View on postgr.es
From: Jonathan Bartlett <johnnyb@eskimo.com>
To: Thomas LeBlanc <thomasatiem@hotmail.com>
Cc: scott.marlowe@ihs.com, pgsql-general@postgresql.org
Date: 2004-05-11T16:54:02Z
Lists: pgsql-general 
> Actually, the database db2 has all ready been created, plus the table names
> are the same, so I can not use pg_dump and restore.

Yes you can, just use pg_dump with the -a flag, and then just use psql
with redirection rather than restore.

Jon