pg_shadow

The view pg_shadow exists for backwards compatibility: it emulates a catalog that existed in PostgreSQL before version 8.1.

Columns 9

Column	Type	Description / reference
`usename`	`name`	User name pg_authid.rolname
`usesysid`	`oid`	ID of this user pg_authid.oid
`usecreatedb`	`bool`	User can create databases
`usesuper`	`bool`	User is a superuser
`userepl`	`bool`	User can initiate streaming replication and put the system in and out of backup mode.
`usebypassrls`	`bool`	User bypasses every row-level security policy, see Section 5.9 for more information.
`passwd`	`text`	Encrypted password; null if none. See pg_authid for details of how encrypted passwords are stored.
`valuntil`	`timestamptz`	Password expiry time (only used for password authentication)
`useconfig`	`text[]`	Session defaults for run-time configuration variables

Column history across versions

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`usename`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`usesysid`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`usecreatedb`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`usesuper`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`userepl`	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`usebypassrls`	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●
`passwd`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`valuntil`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`useconfig`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`usecatupd`	●	●	●	●	●	·	·	·	·	·	·	·	·	·	·	·	·	·

Version history 7

Definition snapshot: english-manuals:1de04f91c90f38e8c3e91df3d28… · English manual source