HomerWelch <hjwxxx(at)home(dot)com> wrote:
> (\h createuser.) I don't recall a method for listing all
> users.
man psql
has a lot of good information.
Log in as postgres (or whoever is your postgres super user), then run
psql, and:
\dS
Will give you a list of the system tables (relations).
\dS pg_user
Will give you the structure of that table, and actually some more help.
SELECT usename, usesuper from pg_shadow;
Will give you a list of the users that are define, and indicate which one
is the super user.
Yves.
----
Yves Dorfsman dorfsmay(at)cuug(dot)ab(dot)ca
http://www.cuug.ab.ca/~dorfsmay