Postgre验证用户有哪些角色

验证PG用户有哪些角色

select r.rolname,ARRAY(
                      select b.rolname 
                      from pg_catalog.pg_auth_members m 
                      join pg_catalog.pg_roles b on (m.member=b.oid) 
                      where m.member=r.oid) as memberof
from  pg_catalog.pg_roles r
where r.rolname~'data|opr' and r.rolcanlogin
order by 1;