I have tried:
alter table <table_name> NOCHECK CONSTRAINT ALL;
and it highlights (squiggles) NOCHECK saying : ERROR: syntax error at or
near "NOCHECK" SQL state: 42601 character 20
but everything I lookup says this this is the way to disable all
constraints on a table.
Also is there a way to disable all existing constraints on all tables
everywhere (specifically all pkey & fkey constraints irrespective of how
they were created) in one statement?
I have searched and searched and find nothing that works.
J.V.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
