Horton

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

Karsten Hilbert <karsten.hilbert@gmx.net>

View thread View on postgr.es
From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
To: pgsql-general@postgresql.org
Date: 2004-05-11T16:44:35Z
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.
Sure you can:

dropdb db2
createdb db2 ...
> >pg_dump -d db1 -t table1 |psql db2

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346