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 |
|---|
oidoid
Row identifier |
pflnamename
Profile name |
pflfailedloginattemptsint4
FAILED_LOGIN_ATTEMPTS parameter value
|
pflfailedauthkeeptimeint4
FAILED_AUTH_KEEP_TIME parameter value (in seconds)
|
pfluserinactivetimeint4
USER_INACTIVE_TIME parameter value (in seconds)
|
pflpasswordreusetimeint4
PASSWORD_REUSE_TIME parameter value (in seconds)
|
pflpasswordreusemaxint4
PASSWORD_REUSE_MAX parameter value
|
pflpasswordlifetimeint4
PASSWORD_LIFE_TIME parameter value (in seconds)
|
pflpasswordgracetimeint4
PASSWORD_GRACE_TIME parameter value (in seconds)
|
pflpasswordminuniqcharsint4
PASSWORD_MIN_UNIQUE_CHARS parameter value
|
pflpasswordminlenint4
PASSWORD_MIN_LEN parameter value
|
pflpasswordrequirecomplexint4
PASSWORD_REQUIRE_COMPLEX parameter value
|
The UNLIMITED and DEFAULT parameter values are stored in pg_profile as -1 and -2, respectively.
