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.
| || ||Role name|
| || ||Role has superuser privileges|
| || ||Role automatically inherits privileges of roles it is a member of|
| || ||Role can create more roles|
| || ||Role can create databases|
| || ||Role can log in. That is, this role can be given as the initial session authorization identifier|
| || ||Role is a replication role. That is, this role can initiate streaming replication (see Section 25.2.5) and set/unset the system backup mode using |
| || ||For roles that can log in, this sets maximum number of concurrent connections this role can make. -1 means no limit.|
| || ||Not the password (always reads as |
| || ||Password expiry time (only used for password authentication); null if no expiration|
| || ||Role bypasses every row level security policy, see Section 5.7 for more information.|
| || ||Role-specific defaults for run-time configuration variables|
| || || ||ID of role|
© 1996–2017 The PostgreSQL Global Development Group
Licensed under the PostgreSQL License.