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

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

  1. Add psql \drg command to display role grants.