From the psql interface, run the \du command:
This will give you the list of all users in the system, plus their role attributes and the list of role groups they are member of.
How to list all users in Postgres
Find out how to get a list of all the users present in a Postgres database, and their permissions
Published