> Actually, the database db2 has all ready been created, plus the table names > are the same, so I can not use pg_dump and restore. Yes you can, just use pg_dump with the -a flag, and then just use psql with redirection rather than restore. Jon ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings