Re: Show INHERIT in \du

On Fri, Feb 15, 2008 at 3:42 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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}
>

I like it -- very compact compared with what we currently have, but
still easy to read.

What about connection limit? I suppose we could combine it into the
privileges column, and refrain from displaying anything for "no
limit".

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

Cheers
BJ