Re: Listing Users

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(at)postgresql(dot)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(at)matrix(dot)gatewaynet(dot)com
mantzios(at)softlab(dot)ece(dot)ntua(dot)gr