Re: How to list and remove a user in postgres ? - Mailing list pgsql-general

HomerWelch <hjwxxx@home.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@cuug.ab.ca
                                         http://www.cuug.ab.ca/~dorfsmay