Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group