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.
