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
>
