Re: psql: Add role's membership options to the \du+ command

From: "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Pavel Luzanov <p(dot)luzanov(at)postgrespro(dot)ru>, Robert Haas <robertmhaas(at)gmail(dot)com>, David Zhang <david(dot)zhang(at)highgo(dot)ca>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>, rmt(at)lists(dot)postgresql(dot)org, horikyota(dot)ntt(at)gmail(dot)com
Subject: Re: psql: Add role's membership options to the \du+ command
Date: 2023-06-23 21:20:22
Message-ID: f8a3b182-43fc-088e-aca8-b6e2c7e026e3@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 6/23/23 12:16 PM, Tom Lane wrote:
> "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
>> On Thu, Jun 22, 2023 at 5:08 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> * I agree that the "tabular" format looks nicer and has fewer i18n
>>> issues than the other proposals.
>
>> As you are on board with a separate command please clarify whether you mean
>> the tabular format but still with newlines, one row per grantee, or the
>> table with one row per grantor-grantee pair.
>
> I'd lean towards a straight table with a row per grantee/grantor.
> I tend to think that faking table layout with some newlines is
> a poor idea. I'm not dead set on that approach though.

[Personal hat]

Generally, I find the tabular view w/o newlines is easier to read, and
makes it simpler to join to other data (though that may not be
applicable here).

Again, I'm not the target user of this feature (until I need to use it),
so my opinion comes with a few grains of salt.

Thanks,

Jonathan

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Cary Huang 2023-06-23 21:31:11 Re: sslinfo extension - add notbefore and notafter timestamps
Previous Message Jonathan S. Katz 2023-06-23 21:18:59 Re: psql: Add role's membership options to the \du+ command