Thread: Information_schema.table_constraints
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.
Thanks
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
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." thank you. that explains.