51.40. pg_profile #

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