3.15. pg_shadow

pg_shadow contains information about database users. The name stems from the fact that this table should not be readable by the public since it contains passwords. pg_user is a view on pg_shadow that blanks out the password field.

The Administrator's Guide contains detailed information about user and permission management.

Table 3-15. pg_shadow Columns

NameTypeReferencesDescription
usenamename User name
usesysidint4 User id (arbitrary number used to reference this user)
usecreatedbbool User may create databases
usetracebool not used
usesuperbool User is a superuser
usecatupdbool  User may update system catalogs. (Even a superuser may not do this unless this attribute is true.)
passwdtext Password
valuntilabstime Account expiry time (only used for password authentication)