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.
ID of this user
User can create databases
User is a superuser
User can initiate streaming replication and put the system in and out of backup mode.
User bypasses every row level security policy, see Section 5.8 for more information.
Not the password (always reads as
Password expiry time (only used for password authentication)
Session defaults for run-time configuration variables