Re: Show INHERIT in \du

--On Donnerstag, Februar 14, 2008 10:27:37 -0300 Alvaro Herrera
<alvherre(at)commandprompt(dot)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