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?
--
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.