Re: \du in psql patchp - Mailing list pgsql-patches

From Peter Eisentraut
Subject Re: \du in psql patchp
Date
Msg-id Pine.LNX.4.30.0101081919150.760-100000@peter.localdomain
Whole thread Raw
In response to \du in psql patchp  (Alex Perel <aperel@verticalscope.com>)
Responses Re: \du in psql patchp  (Alex Perel <aperel@verticalscope.com>)
List pgsql-patches
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/


pgsql-patches by date:

Previous
From: "Robert B. Easter"
Date:
Subject: sql.sgml patch 2 (use this one instead of the first one I sent)
Next
From: Alex Perel
Date:
Subject: Re: \du in psql patchp