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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
