Re: how to list privileges on the database object itself via SQL?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: richard coleman <rcoleman(dot)ascentgl(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: how to list privileges on the database object itself via SQL?
Date: 2023-04-26 17:22:59
Message-ID: 875041.1682529779@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

richard coleman <rcoleman(dot)ascentgl(at)gmail(dot)com> writes:
> Thanks, but no. I am looking for the SQL statement.
> I very rarely venture into psql, unless it's to run an SQL code block from
> the terminal.
> Is there an SQL way to do this?

psql is still a useful reference. Run it with the -E option and
look at the SQL it issues when you say "\l". Trim to fit your
requirements.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message MichaelDBA 2023-04-26 17:35:26 Re: how to list privileges on the database object itself via SQL?
Previous Message richard coleman 2023-04-26 17:20:14 Re: how to list privileges on the database object itself via SQL?