验证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;