> 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