Thread: psql \du no more showing "member of" column
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
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 moredetail. 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&to=16&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.