On Fri, Jun 13, 2008 at 3:33 AM, <timalou2@xxxxxxxxxxxxxxx> wrote: > 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 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.