Updated on 2024-06-03 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.