Re: Restoring db objects , help needed

On Mon, 7 Mar 2005 13:42:48 -0400, Hugo Takada <htakada(at)gmail(dot)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(at)gmail(dot)com
LlamaLand http://netllama.linux-sxs.org