Viewing Enabled and Available Roles

You can list the roles you have enabled in your session using the SHOW ENABLED ROLES statement:

=> SHOW ENABLED_ROLES;     
     name      | setting
---------------+----------
 enabled roles | logreader
(1 row)

You can find the roles available to your account using the SHOW AVAILABLE ROLES statement:

Bob=> SHOW AVAILABLE_ROLES;      
      name       |           setting
-----------------+-----------------------------
 available roles | logreader, logwriter
(1 row)