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.