Updated on 2024-05-07 GMT+08:00

PG_AUTH_HISTORY

PG_AUTH_HISTORY records the authentication history of a role. This system catalog is accessible only to system administrators.

Table 1 PG_AUTH_HISTORY columns

Name

Type

Description

oid

oid

Row identifier (hidden attribute, which must be specified).

roloid

oid

ID of a role.

passwordtime

timestamp with time zone

Time of password creation and change.

rolpassword

text

Ciphertext of the role password. The encryption mode is determined by the GUC parameter password_encryption_type.