49.79. pg_user

The view pg_user provides access to information about database users. This is simply a publicly readable view of pg_shadow that blanks out the password field.

Table 49-80. pg_user Columns

NameTypeDescription
usenamenameUser name
usesysidoidID of this user
usecreatedbboolUser can create databases
usesuperboolUser is a superuser
usereplbool User can initiate streaming replication and put the system in and out of backup mode.
usebypassrlsbool User bypasses every row level security policy, see Section 5.7 for more information.
passwdtextNot the password (always reads as ********)
valuntilabstimePassword expiry time (only used for password authentication)
useconfigtext[]Session defaults for run-time configuration variables