Thread: view users

view users

From
"Joel Lopez"
Date:
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


Re: view users

From
"Scott Morrison"
Date:
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@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Joel Lopez
Sent: Tuesday, February 11, 2003 5:45 PM
To: pgsql-novice@postgresql.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