Top
Enterprise Postgres 16 Operation Guide

C.1 pgx_profile

A system catalog for managing profile information. -1 is stored if DEFAULT is specified for each parameter in the profile, and -2 is stored if UNLIMITED is specified.

Column

Type

Description

oid

oid

Profile identifier
(Primary key constraint)

prfname

name

Profile name
(Unique constraint, NOT NULL constraint)

prfpasswordlifetime

integer

Value of PASSWORD_LIFE_TIME (seconds)
(NOT NULL constraint)

prfpasswordgracetime

integer

Value of PASSWORD_GRACE_TIME (seconds)
(NOT NULL constraint)

prfpasswordreusetime

integer

Value of PASSWORD_REUSE_TIME (seconds)
(NOT NULL constraint)

prfpasswordreusemax

integer

Value of PASSWORD_REUSE_MAX (seconds)
(NOT NULL constraint)

prfpasswordlocktime

integer

Value of PASSWORD_LOCK_TIME (seconds)
(NOT NULL constraint)

prffailedloginattempts

integer

Value of FAILED_LOGIN_ATTEMPTS (seconds)
(NOT NULL constraint)

prfpasswordallowhashed

integer

Value of PASSWORD_ALLOW_HASHED
(NOT NULL constraint)