Information_schema.table_constraints

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.