Postgres Pro
Downloads
Home   >   mailing lists

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

From Jonathan Bartlett
Subject Re: How to move data from 1 database to another?
Date
Msg-id Pine.SUN.4.58.0405110953310.21862@eskimo.com
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.

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

Jon

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: How to move data from 1 database to another?
Next
From: Karsten Hilbert
Date:
Subject: Re: How to move data from 1 database to another?