Well, that would work if the schema, when restored, is free. If not, you'd like to set the schema name in which you restore before restoring. When you use Oracle, you can, using exp/imp, change the schema you restore in by setting properly the program arguments. I understand that this is not possible with postgres, and this would be a nice feature. Regards -- Christophe Doré -----Original Message----- From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Francisco Reyes Sent: jeudi 1 avril 2010 22:20 To: Julio Leyva Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: pg_restore : change schema Julio Leyva writes: > What about alter schema ? How would that help? If I understand correctly, the original poster is trying to do something like: Source DB schema1.table1 And restore it to schema2.table1 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
