On Fri, 2007-07-13 at 20:06 -0500, Michael Glaesemann wrote: > On Jul 13, 2007, at 19:10 , Francisco Reyes wrote: > > > Alternatively is there any easy way to take all data in one schema > > and load it into a target DB and a different schema? > > You might try using the -n flag with pg_dump, replace schema1 with > schema2 in the dump file, and loading the altered dump into the new > database. There may also be some tricks you can play with pg_restore > (on a dump file created with pg_dump -Fc), though I don't know > specifically what offhand. > I would find it helpful if there were an easy way to rename objects (specifically schemas) during the restore process. Let's say I have a development database, and I want to copy the entire schema myapp_dev1 to schema myapp_dev2 on the same database. Currently, it's fairly awkward to do that. How do other people do that? Is it worth trying to add a way for pg_restore to rename object? Or what about an option so pg_restore will not emit the the schema name at all, and the user who restores is can just set their search_path to where they want all the objects to go? Regards, Jeff Davis
