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.

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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Alan Hodgson
Дата:
Сообщение: Re: : PostgreSQL Online Backup
Следующее
От: Rohit Coder
Дата:
Сообщение: Re: Why PGSQL has no developments in the .NET area?