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@gmx.net http://yi.org/peter-e/