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
