47.75. pg_user

Note: The following description applies both to Postgres-XC and PostgreSQL if not described explicitly. You can read PostgreSQL as Postgres-XC except for version number, which is specific to each product.

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 47-76. pg_user Columns

NameTypeDescription
usenamenameUser name
usesysidoidID of this user
usecreatedbboolUser can create databases
usesuperboolUser is a superuser
usecatupdbool User can update system catalogs. (Even a superuser cannot do this unless this column is true.)
usereplbool User can initiate streaming replication and put the system in and out of backup mode.
passwdtextNot the password (always reads as ********)
valuntilabstimePassword expiry time (only used for password authentication)
useconfigtext[]Session defaults for run-time configuration variables