Properties

Name: enabled_roles 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

Name Type Length
  role_name  sql_identifier  -1 
Total: 1 column(s)

SQL


CREATE VIEW enabled_roles AS
    SELECT (a.rolname)::sql_identifier AS role_name FROM pg_authid a WHERE pg_has_role(a.oid, 'USAGE'::text);


ALTER TABLE information_schema.enabled_roles OWNER TO postgres;

See Also

List of views