Обсуждение: Seeing privileges on a schema

In psql, I know that \dp or \dpp will show me which privileges are granted on tables, views, sequences, and functions,
whatit doesn’t appear to be able to do, is show me what privileges are in the schema itself, like if I grant usage on a
schema.Then a \dpp doesn’t produce anything. Is there an easy way to see what privileges are on a schema? 
—
Jay

Sent from my iPad

John Scalia <jayknowsunix@gmail.com> writes:
> In psql, I know that \dp or \dpp will show me which privileges are granted on tables, views, sequences, and
functions,what it doesn’t appear to be able to do, is show me what privileges are in the schema itself, like if I grant
usageon a schema. Then a \dpp doesn’t produce anything. Is there an easy way to see what privileges are on a schema? 

\dn+ includes that.

            regards, tom lane

Thanks, I didn’t realize that.

Sent from my iPad

> On Dec 2, 2020, at 2:00 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> John Scalia <jayknowsunix@gmail.com> writes:
>> In psql, I know that \dp or \dpp will show me which privileges are granted on tables, views, sequences, and
functions,what it doesn’t appear to be able to do, is show me what privileges are in the schema itself, like if I grant
usageon a schema. Then a \dpp doesn’t produce anything. Is there an easy way to see what privileges are on a schema? 
>
> \dn+ includes that.
>
>            regards, tom lane