Postgres Pro
Downloads
Home   >   mailing lists

Re: How to move data from 1 database to another? - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: How to move data from 1 database to another?
Date
Msg-id 20040511184435.B642@hermes.hilbert.loc
Whole thread Raw
In response to Re: How to move data from 1 database to another?  ("Thomas LeBlanc" <thomasatiem@hotmail.com>)
List pgsql-general
Tree view 
> 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

pgsql-general by date:

Previous
From: Jonathan Bartlett
Date:
Subject: Re: How to move data from 1 database to another?
Next
From: Gaetano Mendola
Date:
Subject: Re: Slow network retrieves