Re: pg_dump vs schemas

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.


Michael Glaesemann
grzm seespotcode net