Catalogs: pg_roles
49.70. pg_roles
The view pg_roles provides access to information about database roles. This is simply a publicly readable view of pg_authid that blanks out the password field.
This view explicitly exposes the OID column of the underlying table, since that is needed to do joins to other catalogs.
Table 49-71. pg_roles Columns
| Name | Type | References | Description |
|---|---|---|---|
rolname | name | Role name | |
rolsuper | bool | Role has s
 |