Horton
Menu

Thread

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Add psql \drg command to display role grants.

  1. psql \du no more showing "member of" column

    Luca Ferrari <fluca1978@gmail.com> — 2023-10-13T11:39:17Z

    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

  2. Re: psql \du no more showing "member of" column

    hubert depesz lubaczewski <depesz@depesz.com> — 2023-10-13T13:04:29Z

    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

  3. Re: psql \du no more showing "member of" column

    Ian Lawrence Barwick <barwick@gmail.com> — 2023-10-13T13:06:09Z

    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

  4. Re: psql \du no more showing "member of" column

    Luca Ferrari <fluca1978@gmail.com> — 2023-10-13T13:51:53Z

    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

  5. Re: psql \du no more showing "member of" column

    Lele Gaifax <lele@metapensiero.it> — 2023-10-13T15:45:35Z

    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

  6. Re: psql \du no more showing "member of" column

    Pavel Luzanov <p.luzanov@postgrespro.ru> — 2023-10-13T20:54:20Z

    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

  7. Re: psql \du no more showing "member of" column

    Bruce Momjian <bruce@momjian.us> — 2023-10-18T17:40:56Z

    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.