PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SYSTEM CATALOGS / SYSTEM VIEWS

pg_user

Read PG 18 manual ↗

The view pg_user provides access to information about database users.

Kind: System views
Columns in this snapshot: 9
Definition source: English manual

Columns 9

Column	Type	Description / reference
`usename`	`name`	User name
`usesysid`	`oid`	ID of this user
`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`	Not the password (always reads as ********)
`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 6

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