In PostgreSQL, all roles can be members of other roles.
With that in mind, creating a “group” role is no different
than creating any other role (and then passing the
proper options following WITH).
CREATE ROLE group_role WITH <list of permissions> ROLE member_role;