PG_USER v14

The PG_USER view provides information about the database users. It provides information specific to EDB Postgres Advanced Server in addition to the information provided in the PostgreSQL pg_user view.

NameTypeDescription
uselockdatedateThe time when the account was last locked; null if the account was never locked before.
useaccountstatusintegerBit mask identifying user account status.
usepasswordexpiredateThe time after which a password change will be forced at the next login.