The catalog pg_profile
lists all profiles available for your cluster. For details on profiles, see CREATE PROFILE.
Profiles are cluster-wide, so pg_profile
is shared across all databases of a cluster. This catalog is not publicly readable.
Table 54.40. pg_profile
Columns
Column Type Description |
---|
oid oid
Row identifier |
pflname name
Profile name |
pflfailedloginattempts int4
FAILED_LOGIN_ATTEMPTS parameter value
|
pflfailedauthkeeptime int4
FAILED_AUTH_KEEP_TIME parameter value (in seconds)
|
pfluserinactivetime int4
USER_INACTIVE_TIME parameter value (in seconds)
|
pflpasswordreusetime int4
PASSWORD_REUSE_TIME parameter value (in seconds)
|
pflpasswordreusemax int4
PASSWORD_REUSE_MAX parameter value
|
pflpasswordlifetime int4
PASSWORD_LIFE_TIME parameter value (in seconds)
|
pflpasswordgracetime int4
PASSWORD_GRACE_TIME parameter value (in seconds)
|
pflpasswordminuniqchars int4
PASSWORD_MIN_UNIQUE_CHARS parameter value
|
pflpasswordminlen int4
PASSWORD_MIN_LEN parameter value
|
pflpasswordrequirecomplex int4
PASSWORD_REQUIRE_COMPLEX parameter value
|
The UNLIMITED
and DEFAULT
parameter values are stored in pg_profile
as -1
and -2
, respectively.