Re: view users

From within the psql application, you can do

SELECT usename FROM pg_user;

I don't know of any easy way from outside of the app like the way you list
the databases.

-- Scott

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Joel Lopez
Sent: Tuesday, February 11, 2003 5:45 PM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] view users

Hi,

I've created a db and a user. I can see the db using 'psql -l' but how do
I see the users?

thanks,
Joel

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster