Re: psql \du no more showing "member of" column

2023年10月13日(金) 20:47 Luca Ferrari <fluca1978@gmail.com>:
>
> Hi all,
> in version 16 psql does not show anymore the "member of" group
> information when showing users with \du.
>
> The query (still working fine) in previous versions was:
>
> SELECT r.rolname, r.rolsuper, r.rolinherit,
>  r.rolcreaterole, r.rolcreatedb, r.rolcanlogin,
>  r.rolconnlimit, r.rolvaliduntil,
>  ARRAY(SELECT b.rolname
>        FROM pg_catalog.pg_auth_members m
>        JOIN pg_catalog.pg_roles b ON (m.roleid = b.oid)
>        WHERE m.member = r.oid) as memberof
> , r.rolreplication
> , r.rolbypassrls
> FROM pg_catalog.pg_roles r
> WHERE r.rolname !~ '^pg_'
> ORDER BY 1;
>
>
> while now it is:
>
> SELECT r.rolname, r.rolsuper, r.rolinherit,
>  r.rolcreaterole, r.rolcreatedb, r.rolcanlogin,
>  r.rolconnlimit, r.rolvaliduntil
> , r.rolreplication
> , r.rolbypassrls
> FROM pg_catalog.pg_roles r
> WHERE r.rolname !~ '^pg_'
> ORDER BY 1;
>
>
> at least, as it is shown by `psql -E`.
> I wonder why this information has been removed, I'm not able to find
> this in the documentation.

FWIW the explanation is in commit 0a1d2a7df8:

  https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=0a1d2a7df852f16c452eef8a83003943125162c7

and also noted in the release notes:

  https://www.postgresql.org/docs/16/release-16.html#RELEASE-16-PSQL

Regards

Ian Barwick