Re: psql: Add role's membership options to the \du+ command
Pavel Luzanov <p.luzanov@postgrespro.ru>
From: Pavel Luzanov <p.luzanov@postgrespro.ru>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: David Zhang <david.zhang@highgo.ca>,
"pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>
Date: 2023-03-20T08:49:55Z
Lists: pgsql-hackers
Attachments
- v4-0001-psql-show-membership-options-in-the-du-command.patch (text/x-patch) patch v4-0001
On 10.03.2023 15:06, Pavel Luzanov wrote: > I missed the comment at the beginning of the file about version 9.2. I > will return the version check for rolbypassrls. >> + <para> >> + Shown within each row, in newline-separated format, are the >> memberships granted to >> + the role. The presentation includes both the name of the >> grantor >> + as well as the membership permissions (in an abbreviated format: >> + <literal>a</literal> for admin option, <literal>i</literal> >> for inherit option, >> + <literal>s</literal> for set option.) The word >> <literal>empty</literal> is printed in >> + the case that none of those permissions are granted. >> + See the <link >> linkend="sql-grant"><command>GRANT</command></link> command for their >> meaning. >> + </para> >> + <para> >> + If the form <literal>\dg+</literal> is used the comment >> attached to the role is shown. >> </para> > > Thanks. I will replace the description with this one. > >> I would suggest tweaking the test output to include regress_du_admin >> and also to make regress_du_admin a CREATEROLE role with LOGIN. > > Ok. Please review the attached version 4 with the changes discussed. ----- Pavel Luzanov
Commits
-
Add psql \drg command to display role grants.
- d65ddaca93f6 17.0 landed
- 0a1d2a7df852 16.0 landed