HomeMogDBMogDB StackUqbar
v2.0

Documentation:v2.0

Supported Versions:

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 Role password that is encrypted using MD5 or SHA256, or that is not encrypted
Copyright © 2011-2024 www.enmotech.com All rights reserved.