Re: Information_schema.table_constraints

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Ravi Krishna <s_ravikrishna(at)aol(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Information_schema.table_constraints
Date: 2022-08-25 22:03:11
Message-ID: 988bb91f-89d2-bb38-4b46-846c5da6e20a@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ravi Krishna 2022-08-25 23:30:21 Re: Information_schema.table_constraints
Previous Message Ravi Krishna 2022-08-25 20:53:53 Information_schema.table_constraints