PG_AUTH_HISTORY

PG_AUTH_HISTORY records the authentication history of a role. This system catalog is accessible only to users with the SYSADMIN permission.

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

Parent topic:System Catalogs

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.