Net Tree Inc. wrote:
Hi all,
I am dumping both schema and data from old database to new one. The
new database schema is somehow contain slightly different schema then
the old one. When I do restore it shown alot errors related with
constraints. How can I dump and to restore from old to new without
dealing with constraint and just forces data dump to where it suppose
to belong?
if you're dumping the schema and the data, you should be restoring into
an empty database, not into an existing database.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general