Viewing Named Roles
To view the names of all roles users can access, along with any roles that have been assigned to those roles, query the V_CATALOG.ROLES system table.
=> SELECT * FROM roles; role_id | name | assigned_roles -------------------+-----------------+---------------- 45035996273704964 | public | 45035996273704966 | dbduser | 45035996273704968 | dbadmin | dbduser* 45035996273704972 | pseudosuperuser | dbadmin* 45035996273704974 | logreader | 45035996273704976 | logwriter | 45035996273704978 | logadmin | logreader, logwriter (7 rows)
Note: An asterisk (*) in the output means that role was granted WITH ADMIN OPTION.