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