Re: Need to check disabled constraints
| От | David G. Johnston |
|---|---|
| Тема | Re: Need to check disabled constraints |
| Дата | |
| Msg-id | CAKFQuwb2bLY3LQ9N9adkBC-86OjZNWDf-OocvoXGRqwjFHVNaw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Need to check disabled constraints (Sohel Tamboli <sohel.tamboli0016@gmail.com>) |
| Список | pgsql-admin |
Hi,Any updates?Also I need to disable all FK in schema/database for database migration. How can I achieve that?
pg_dump/pg_restore handles this for you...but see:
"DISABLE/ENABLE [ REPLICA | ALWAYS ] TRIGGER"
On 25-Jan-2018 12:57 pm, "Sohel Tamboli" <sohel.tamboli0016@gmail.com> wrote: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?
A doc skim should have led you to pg_triggers in the "System Catalogs" chapter. The column tgenabled looks like what you are looking for.
David J.
В списке pgsql-admin по дате отправления: