Re: Show INHERIT in \du

--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.  Legend of
> letter at the bottom of the output, or some such.  So instead of
>
> alvherre=# \du
>                                List of roles
>  Role name | Superuser | Create role | Create DB | Connections | Member
> of
> -----------+-----------+-------------+-----------+-------------+---------
> --  alvherre  | yes       | yes         | yes       | no limit    | {}
>  foo       | no        | no          | yes       | no limit    | {} (2
> rows)
>
> We would have something like
>
> alvherre=# \du
>                  List of roles
>  Role name | Attributes | Connections | Member of
> -----------+------------+-------------+-----------
>  alvherre  | SRDI       | no limit    | {}
>  foo       |   D        | no limit    | {}
> (2 rows)
> Attributes: S -- superuser
>             R -- create role
>         D -- create database
>         I -- inherit

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. And you are 
always able to get a compact view with \x and \du <rolename>.

--  Thanks
                   Bernd