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.
Pssst! Also check my latest YouTube video
I am writing a book on how to create a successful blog as a developer.
It will be released late February.
Signup to my newsletter
to get 2/3 free chapters in your inbox in the next few weeks!