Re: Need to check disabled constraints - Mailing list pgsql-admin

From Sohel Tamboli
Subject Re: Need to check disabled constraints
Date
Msg-id CAAbZosBmhPDPmXyoQ-XRsoKL9Sgf8L3XrnrJOX7epTivEus6VQ@mail.gmail.com
Whole thread Raw
In response to Need to check disabled constraints  (Sohel Tamboli <sohel.tamboli0016@gmail.com>)
Responses Re: Need to check disabled constraints
List pgsql-admin
Hi, 

Any updates? 
Also I need to disable all FK in schema/database for database migration. How can I achieve that? 

Thanks, 
Sohel

On 25-Jan-2018 12:57 pm, "Sohel Tamboli" <sohel.tamboli0016@gmail.com> wrote:
Hi, 

Can anyone please let me know how I can check disabled constraints in postgresql 9.1 database. 
I know that ALTER TABLE tablename DISABLE TRIGGER ALL; can disable foriegn constraints, but how I can check if it is really disabled. Similarly I need to check if constraint is enable. 

In oracle we have option to check status of constraint in user_constraints table but do we have same in postgresql as well? 

Appreciate your response. 

Thanks. 

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [ADMIN] standby upgrade questions
Next
From: Siro Mateos De La Rosa
Date:
Subject: Disable animations