Re: Show INHERIT in \du - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Show INHERIT in \du
Date
Msg-id 9543.1203007337@sss.pgh.pa.us
Whole thread Raw
In response to Re: Show INHERIT in \du  (Bernd Helmle <mailings@oopsware.de>)
Responses Re: Show INHERIT in \du
Re: Show INHERIT in \du
List pgsql-hackers
Bernd Helmle <mailings@oopsware.de> writes:
> --On Donnerstag, Februar 14, 2008 10:27:37 -0300 Alvaro Herrera 
> <alvherre@commandprompt.com> wrote:
>> I wonder if it's possible to create a more compact output -- say, a
>> fixed-width column, with a letter for each enabled attribute, or a space
>> in the respective position when the attribute is disabled.

> Hmm, i don't think that makes it easier to read, especially when you get a 
> long list of role names and the legend at the bottom of it.

Also, what about localization?  In some languages you might need to
resort to ugly phrasings to avoid having the same prefix letter for
several attributes.

Now that psql prints multiline field values nicely, maybe it'd work
to fold all the boolean attributes into one column.  I'm imagining
something like

Role name | Privileges  | Member of
----------+-------------+-----------
postgres  | superuser   | {}         | create role |         | create db   |
joeblow   |             | {users}
foobar    |             | {users}

        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Timezone view
Next
From: Tom Lane
Date:
Subject: Re: Reworking WAL locking