PostgreSQL - Role Management
Find all users in the it_developer
role:
SELECT r.rolname
FROM pg_roles r
WHERE r.oid IN (
SELECT m.member
FROM pg_auth_members m
JOIN pg_roles b ON (m.roleid = b.oid)
WHERE b.rolname='it_developer'
);