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
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 |