SQL

add role to group postgres

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;