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 6: Have you searched our list archives? http://archives.postgresql.org
