Are you an LLM? You can read better optimized documentation at /en/docs/7.0.0/database_reference/pg_auth_history.md for this page in Markdown format
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. |