fail: alter table NOCHECK CONSTRAINT ALL; - Mailing list pgsql-general

From J.V.
Subject fail: alter table NOCHECK CONSTRAINT ALL;
Date
Msg-id 4E8B4EAF.6050307@gmail.com
Whole thread Raw
Responses Re: fail: alter table NOCHECK CONSTRAINT ALL;  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: how to disable all pkey/fkey constraints globally
Next
From: "J.V."
Date:
Subject: how to select one column into another in same table?