The catalogpg_profile lists all profiles available for your cluster. For details on profiles, seeCREATE PROFILE.
Profiles are cluster-wide, sopg_profile is shared across all databases of a cluster. This catalog is not publicly readable.
Table 51.39. 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
|
TheUNLIMITED andDEFAULT parameter values are stored inpg_profile as-1 and-2, respectively.
