On Fri, Jun 13, 2008 at 3:33 AM, <timalou2(at)netcourrier(dot)com> wrote:
> Is it possible to restore a backup schema to another schema ?
> For instance I create a backup of a database called "source" with its public schema with pg_backup
> I want to restore this backup in a database called "dest" into a new schema called public2
Easiest way is to edit the pg_dump file by hand or use sed / awk to
change it on the fly.
If there's a lot of data and that makes it tough to do that, look into
dumping the schema and data separately, but this doesn't always work
quite right for some complex schemas.
In response to
pgsql-admin by date
|Next:||From: Scott Marlowe||Date: 2008-06-17 02:43:30|
|Subject: Re: Advice on running two database clusters on one server machine|
|Previous:||From: Scott Marlowe||Date: 2008-06-17 02:32:58|
|Subject: Re: I: Purge Oid|