Re: \du in psql patchp

Alex Perel writes:

> I quickly put together a patch to psql that allows one to view current
> system users. The code is very simple, but it seems to work.
>
> The usage is as follows:
>
> database=# \du [username]

Hi, we're currently in beta, but this one seems reasonable to add in 7.2.

> I apologize in advance for my lack of C skills, and I will gladly
> accept any criticism or advice. I'm hoping I can figure out a way
> to write an equivalent for groups, once I determine how to
> get around the grolist integer[] column in pg_group.

I think the pg_group table will be redesigned in 7.2 so it can be queried
better.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/