-
![thumbnail]()
pgadmin - PostgreSQL, display role members - Database Administrators Stack Exchange
August 12, 2019 at 1:37:32 PM GMT+2 * - permalink -SELECT r.rolname as username,r1.rolname as "role"
FROM pg_catalog.pg_roles r LEFT JOIN pg_catalog.pg_auth_members m
ON (m.member = r.oid)
LEFT JOIN pg_roles r1 ON (m.roleid=r1.oid)
WHERE r.rolcanlogin
ORDER BY 1;
-
https://dba.stackexchange.com/questions/136858/postgresql-display-role-members
