Restore a backup into a new schema

From: timalou2(at)netcourrier(dot)com
To: pgsql-admin(at)postgresql(dot)org
Subject: Restore a backup into a new schema
Date: 2008-06-13 09:33:08
Message-ID: mnet1.1213349588.23549.timalou2@netcourrier.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

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

Thanks a lot for your reply,

Thierry

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Miracapillo Alessandro 2008-06-13 09:52:02 I: Purge Oid
Previous Message Geoffrey 2008-06-12 19:20:55 Re: How is the default encoding determined