Re: Information_schema.table_constraints

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Information_schema.table_constraints
Дата
Msg-id 988bb91f-89d2-bb38-4b46-846c5da6e20a@aklaver.com
обсуждение исходный текст
Ответ на Information_schema.table_constraints  (Ravi Krishna <s_ravikrishna@aol.com>)
Ответы Re: Information_schema.table_constraints  (Ravi Krishna <s_ravikrishna@aol.com>)
Список pgsql-general
On 8/25/22 13:53, Ravi Krishna wrote:
> Any idea why select on this table does not yield any output for a user 
> who otherwise can get output for other information_schema tables. Does 
> this table require any special privilege compared to other tables of 
> information_schema.


https://www.postgresql.org/docs/current/infoschema-table-constraints.html

"The view table_constraints contains all constraints belonging to tables 
that the current user owns or has some privilege other than SELECT on."

> Thanks


-- 
Adrian Klaver
adrian.klaver@aklaver.com



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

Предыдущее
От: Ravi Krishna
Дата:
Сообщение: Information_schema.table_constraints
Следующее
От: Ravi Krishna
Дата:
Сообщение: Re: Information_schema.table_constraints