Re: Restoring db objects , help needed - Mailing list pgsql-general

From Lonni J Friedman
Subject Re: Restoring db objects , help needed
Date
Msg-id 7c1574a905030709541eb06e09@mail.gmail.com
Whole thread Raw
In response to Restoring db objects , help needed  (Hugo Takada <htakada@gmail.com>)
Responses Re: Restoring db objects , help needed  (Hugo <htakada@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Ioannis Theoharis
Date:
Subject: Re: About Access paths
Next
From: "Rick Schumeyer"
Date:
Subject: postgresql vs mysql performance comparison