SELECT * FROM pg roles

SELECT * FROM pg_roles;

rolname | rolsuper | rolinherit | rolcreaterole | rolcreatedb | rolcanlogin | rolreplication | rolconnlimit | rolpassword | rolvaliduntil | rolbypassrls | rolconfig | oid
.../...

Related

• CREATE USER

See also

• PostgreSQL: Database roles, CREATE USER, CREATE ROLE, \du, \du+, create user, Alter user