Rechercher les utilisateurs dans un groupe

select rg.rolname, users.rolname from pg_catalog.pg_roles rg

join pg_catalog.pg_auth_members m on (m.roleid = rg.oid)

join pg_catalog.pg_roles users on (users.oid = m.member)

where rg.rolname like 'diadanalyse%'

order by 1, 2;

select rg.rolname, users.rolname from pg_catalog.pg_roles rg

join pg_catalog.pg_auth_members m on (m.roleid = rg.oid)

join pg_catalog.pg_roles users on (users.oid = m.member)

where users.rolname = 'login'

order by 1, 2;