Re: How to get all users under a group

To answer my own question:

SELECT g.groname , u.usename AS "User name"
FROM pg_catalog.pg_user u
left join pg_catalog.pg_group g on(u.usesysid = ANY(g.grolist))
ORDER BY 1, 2;




> 
> I know \du+ can get all group info for each user.
> 
> Could someone tell me how to get all users under each group please?
> 
> such as provide the group name, showing all users under the group.
> 
> Thanks,
> Emi
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings