PG_SHADOW
PG_SHADOW displays properties of all roles that are marked as rolcanlogin in PG_AUTHID.
The name stems from the fact that this view should not be readable by the public since it contains passwords. PG_USER is a publicly readable view on PG_SHADOW that blanks out the password column.
Table 1 PG_SHADOW columns
PG_AUTHID.rolname | |||
PG_AUTHID.oid | |||
Users can update a view. Even the system administrator cannot do this unless this column is true. | |||
User can initiate streaming replication and put the system in and out of backup mode. | |||
Password (possibly encrypted); null if none. See PG_AUTHID for details about how encrypted passwords are stored. | |||
Feedback