From: | Ian Lawrence Barwick <barwick(at)gmail(dot)com> |
---|---|
To: | Luca Ferrari <fluca1978(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: psql \du no more showing "member of" column |
Date: | 2023-10-13 13:06:09 |
Message-ID: | CAB8KJ=gzLioGHjqhpYGMNpeWj4bKbaZvh13b5tKeU5meKhLrGg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2023年10月13日(金) 20:47 Luca Ferrari <fluca1978(at)gmail(dot)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:
and also noted in the release notes:
https://www.postgresql.org/docs/16/release-16.html#RELEASE-16-PSQL
Regards
Ian Barwick
From | Date | Subject | |
---|---|---|---|
Next Message | Jehan-Guillaume de Rorthais | 2023-10-13 13:10:06 | Re: Postgresql HA cluster |
Previous Message | hubert depesz lubaczewski | 2023-10-13 13:04:29 | Re: psql \du no more showing "member of" column |