I've honestly never tried doing that. The only method that I can
think of is to manually rename the schema inside your dump before
importing/restoring.
Mind if i ask why you want/need to do this?
On Tue, 8 Mar 2005 07:51:53 -0400, Hugo <htakada@gmail.com> wrote:
> Hi ,
> thanks for the advice, I checked the pg_restore command and I can
> restore individual objects to different databases, but what I'm trying
> to do is to restore a schema X renamed to schema B in the same
> database, when I restore the db object it always restores it to the
> original schema, is it possible to restore the object to a different
> schema in the same database?
>
> thanks
>
> Hugo
>
> On Mon, 7 Mar 2005 09:54:04 -0800, Lonni J Friedman <netllama@gmail.com> wrote:
> > On Mon, 7 Mar 2005 13:42:48 -0400, Hugo Takada <htakada@gmail.com> wrote:
> > > hello,
> > >
> > > Is it possible to restore a DB Schema in a different schema but in the
> > > same Database? or restore the schema with a different name? or restore
> > > a set of objects into a different schema from where they were
> > > backed-up?
> >
> > You can definitely restore a dump into a database with a different
> > name. Just specify the DB name in your pg_restore command. The same
> > should be the case for individual data objects and the schema itself.
> > Just use the -d option.
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama@gmail.com
LlamaLand http://netllama.linux-sxs.org
