Thread: Listing Users

I am familiar with the SQL commands like CREATE USER, DROP USER, and
ALTER USER, but how as an administrator can I get a list of the current
users in PostGreSQL?

-Kyle

> I am familiar with the SQL commands like CREATE USER, DROP USER, and
> ALTER USER, but how as an administrator can I get a list of the
> current users in PostGreSQL?

Have a look at pg_shadow table ?
I'm not sure this is the most efficient way to do that, anyway

select * from pg_user, pg_group

On Wed, 2003-03-19 at 01:26, Kyle wrote:
> I am familiar with the SQL commands like CREATE USER, DROP USER, and
> ALTER USER, but how as an administrator can I get a list of the current
> users in PostGreSQL?
>
> -Kyle
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
--
Hadley Willan > Systems Development > Deeper Design Limited. +64(7)377-3328
hadley.willan@deeperdesign.co.nz > www.deeperdesign.com > +64(21)-28-41-463
Level 1, 4 Tamamutu St, PO Box 90, TAUPO 2730, New Zealand.