Re: Listing Users - Mailing list pgsql-sql

From Achilleus Mantzios
Subject Re: Listing Users
Date
Msg-id Pine.LNX.4.44.0303191438400.22948-100000@matrix.gatewaynet.com
Whole thread Raw
In response to Listing Users  (Kyle <kyle@ccidomain.com>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Kyle
Date:
Subject: Listing Users
Next
From: "Sjors"
Date:
Subject: Re: howto/min values