On Mon, 7 Mar 2005 13:42:48 -0400, Hugo Takada <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] LlamaLand http://netllama.linux-sxs.org ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
