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: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

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,



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-2017 The PostgreSQL Global Development Group