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

From: Jonathan Bartlett <johnnyb(at)eskimo(dot)com>
To: Thomas LeBlanc <thomasatiem(at)hotmail(dot)com>
Cc: scott(dot)marlowe(at)ihs(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: How to move data from 1 database to another?
Date: 2004-05-11 16:54:02
Message-ID: Pine.SUN.4.58.0405110953310.21862@eskimo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gaetano Mendola 2004-05-11 16:59:36 Re: Slow network retrieves
Previous Message Karsten Hilbert 2004-05-11 16:44:35 Re: How to move data from 1 database to another?