how to disable all pkey/fkey constraints globally

From: "J(dot)V(dot)" <jvsrvcs(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: how to disable all pkey/fkey constraints globally
Date: 2011-10-04 17:59:44
Message-ID: 4E8B4990.5070103@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rohit Coder 2011-10-04 18:10:43 Re: Why PGSQL has no developments in the .NET area?
Previous Message Alan Hodgson 2011-10-04 17:57:48 Re: : PostgreSQL Online Backup