The pg_shadow view shows properties of all roles that are marked as rolcanlogin in pg_authid.
Overview
The pg_shadow view contains the following columns:
Column name | Type | Description |
usename | name | The name of the user. |
usesysid | oid | The ID of the user. |
usecreatedb | bool | The user can create databases. |
usesuper | bool | The user is a superuser. |
userepl | bool | The user can initiate streaming replication and enable or disable the backup mode for the system. |
usebypassrls | bool | Whether the user can bypass all row-level security policies. |
passwd | text | The password that may be encrypted. The value is empty if no password is used. |
valuntil | timestamptz | The password expiration time that is used only for password authentication. |
useconfig | text[] | The session default value for the runtime configuration variable. |