how to disable all pkey/fkey constraints globally - Mailing list pgsql-general

From J.V.
Subject how to disable all pkey/fkey constraints globally
Date
Msg-id 4E8B4990.5070103@gmail.com
Whole thread Raw
Responses Re: how to disable all pkey/fkey constraints globally  (John R Pierce <pierce@hogranch.com>)
Re: how to disable all pkey/fkey constraints globally  (<depstein@alliedtesting.com>)
List pgsql-general
Is there a generic way to drop just all primary key and foreign key
constraints on a given table?

I know how to do given the specific name of the constraint.

same question but one statement that would just disable all primary key
and foreign key constraints on a given database?

and am assuming the reverse could not be done because would have to
re-create each one individually?

Maybe I do not want to drop, so is there a way to simply disable all
globally (not drop) & then enable all globally?

thanks


J.V.

pgsql-general by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: : PostgreSQL Online Backup
Next
From: Rohit Coder
Date:
Subject: Re: Why PGSQL has no developments in the .NET area?