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