> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of J.V.
> Sent: Friday, October 21, 2011 1:11 AM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] how to disable all pkey/fkey constraint
On 10/20/2011 05:10 PM, J.V. wrote:
> Is there a simpler way than this to query the database for meta-data and
> get the constraint definitions?
>
> If I have the constraint name (which I do), I could store the constraint
> definition to a file or database table and recreate them if I could get
>
[mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of J.V.
Sent: Tuesday, October 04, 2011 10:00 PM
To: pgsql-general
Subject: [GENERAL] how to disable all pkey/fkey constraints globally
Is there a generic way to drop just all primary key and foreign key constraints
on a given table?
I know
have a look on pg_constraints , pg_tables
regards
From: Joe Abbate
To: pgsql-general@postgresql.org
Sent: Wednesday, October 5, 2011 11:27 AM
Subject: Re: [GENERAL] how to disable all pkey/fkey constraints globally
On 10/05/2011 04:49 AM, depst
l
>> Subject: [GENERAL] how to disable all pkey/fkey constraints globally
>>
>> 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.
>>
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of J.V.
> Sent: Tuesday, October 04, 2011 10:00 PM
> To: pgsql-general
> Subject: [GENERAL] how to disable all pkey/fkey constraints globally
>
>
On 10/04/11 10:59 AM, J.V. wrote:
Maybe I do not want to drop, so is there a way to simply disable all
globally (not drop) & then enable all globally?
IF there was such a method (I don't think there is), to reenable the
constraints would require going through every single row of every single
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 assumi
