psql \du no more showing "member of" column

From: Luca Ferrari <fluca1978(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: psql \du no more showing "member of" column
Date: 2023-10-13 11:39:17
Message-ID: CAKoxK+72Emumren=Oacvt7E9RD6S3aTbvnFxgrR0gV+=wYwoqw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thanks,
Luca

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jason Grammenos 2023-10-13 12:02:53 RE: Postgresql HA cluster
Previous Message Laurenz Albe 2023-10-13 06:05:38 Re: Can not drop partition if exist foreign keys