postgresql query to show the groups of a user

Question

Hello,
If I create a user in a group, like:

create role user_1 login inherit in role group_1;

later, with which query could I retrieve to which group(s) a user belongs to ?

Thanks !

Answer 1

Check pg_roles, pg_authid and pg_auth_members to get the details about roles.