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.
Name | 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 |