psql \du no more showing "member of" column

On Fri, Oct 13, 2023 at 01:39:17PM +0200, Luca Ferrari wrote:

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.

Release notes show:

https://why-upgrade.depesz.com/show?from=15.4&to=16&keywords=%5Cdu

Add psql command \drg to show role membership details (Pavel Luzanov)
The Member of output column has been removed from \du and \dg because this new command displays this informaion in more detail.

Best regards,

depesz

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

On Fri, Oct 13, 2023 at 3:04 PM hubert depesz lubaczewski
<depesz@depesz.com> wrote:

On Fri, Oct 13, 2023 at 01:39:17PM +0200, Luca Ferrari wrote:

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.

Release notes show:

https://why-upgrade.depesz.com/show?from=15.4&amp;to=16&amp;keywords=%5Cdu

Thanks, I totally missed.
Luca

Ian Lawrence Barwick <barwick@gmail.com> writes:

and also noted in the release notes:

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

FWIW, I noticed a small typo in the relevant entry: s/informaion/information/

ciao, lele.
--
nickname: Lele Gaifax | Dire che Emacs è "conveniente" è come
real: Emanuele Gaifas | etichettare l'ossigeno come "utile"
lele@etour.tn.it | -- Rens Troost

Hi,

On 13.10.2023 16:06, Ian Lawrence Barwick wrote:

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.

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

Some explanation can be found at the beginning of this article:

    https://postgrespro.com/blog/pgsql/5970285

--
Pavel Luzanov
Postgres Professional: https://postgrespro.com

On Fri, Oct 13, 2023 at 05:45:35PM +0200, Lele Gaifax wrote:

Ian Lawrence Barwick <barwick@gmail.com> writes:

and also noted in the release notes:

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

FWIW, I noticed a small typo in the relevant entry: s/informaion/information/

ciao, lele.

Thanks, fix applied.

--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com

Only you can decide what is important to you.