PG_SHADOW
PG_SHADOW displays properties of all roles that are marked as rolcanlogin in PG_AUTHID.
This view is not readable to all users because it contains passwords. PG_USER is a publicly readable view on PG_SHADOW that blanks out the password column.
Column | Type | Reference | Description |
|---|---|---|---|
usename | Name | PG_AUTHID.rolname | User name |
usesysid | OID | PG_AUTHID.oid | ID of a user |
usecreatedb | boolean | - | Indicates that the user can create databases. |
usesuper | boolean | - | Indicates that the user is an administrator. |
usecatupd | boolean | - | Indicates that the user can update system catalogs. Even the system administrator cannot do this unless this column is true. |
userepl | boolean | - | User can initiate streaming replication and put the system in and out of backup mode. |
passwd | Text | - | Password (possibly encrypted); null if none. See PG_AUTHID for details about how encrypted passwords are stored. |
valbegin | Timestamp with time zone | - | Account validity start time; null if no start time |
valuntil | Timestamp with time zone | - | Password expiry time; null if no expiration |
respool | Name | - | Resource pool used by the user |
parent | OID | - | Parent resource pool |
spacelimit | Text | - | The storage space of the permanent table. |
tempspacelimit | Text | - | The storage space of the temporary table. |
spillspacelimit | Text | - | The operator disk flushing space. |
useconfig | text[ ] | - | Session defaults for runtime configuration variables |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
