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@xxxxxxxxx> 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@xxxxxxxxx> wrote: > > On Mon, 7 Mar 2005 13:42:48 -0400, Hugo Takada <htakada@xxxxxxxxx> 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@xxxxxxxxx LlamaLand http://netllama.linux-sxs.org ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
