> -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
>
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
the definition.
This seems like a very sim
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
On 10/05/2011 04:49 AM, depst...@alliedtesting.com wrote:
>> -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
> -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
>
> Is there a generic way
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
