script to find what are the users associated with group in AWS Redshift

 

script to find  what are the users associated with group in AWS Redshift:

select usename 

from pg_user , pg_group

where pg_user.usesysid = ANY(pg_group.grolist) and 

      pg_group.groname='<group_name>';