pg_rolesThe 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.
Table 52.83. pg_roles Columns
|
Column Type Description |
|---|
|
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. A replication role can initiate replication connections and create and drop replication slots. |
|
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.8 for more information. |
|
Role-specific defaults for run-time configuration variables |
|
ID of role |
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.