Thread: Listing Users

Listing Users

From
Kyle
Date:
What is the SQL command to list users?

CREATE USER, DROP USER, ALTER USER,  xxxx USER

I just can't seem to find the command to list them.

-Kyle



Re: Listing Users

From
Achilleus Mantzios
Date:
On Wed, 19 Mar 2003, Kyle wrote:

> What is the SQL command to list users?
> 
> CREATE USER, DROP USER, ALTER USER,  xxxx USER
> 
> I just can't seem to find the command to list them.

SELECT * from pg_user ;  

> 
> -Kyle
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> 

-- 
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel:    +30-210-8981112
fax:    +30-210-8981877
email:  achill@matrix.gatewaynet.com       mantzios@softlab.ece.ntua.gr