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 51.39. 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.
