PG_USER¶
PG_USER displays information about users who can access the database.
Name | Type | Description |
|---|---|---|
usename | name | User name |
usesysid | oid | ID of this user |
usecreatedb | boolean | Whether the user has the permission to create databases |
usesuper | boolean | whether the user is the initial system administrator with the highest rights. |
usecatupd | boolean | whether the user can directly update system tables. Only the initial system administrator whose usesysid is 10 has this permission. It is not available for other users. |
userepl | boolean | Whether the user has the permission to duplicate data streams |
passwd | text | Encrypted user password. The value is displayed as |
valbegin | timestamp with time zone | Account validity start time; null if no start time |
valuntil | timestamp with time zone | Password expiry time; null if no expiration |
respool | name | Resource pool where the user is in |
parent | oid | Parent user OID |
spacelimit | text | The storage space of the permanent table. |
tempspacelimit | text | The storage space of the temporary table. |
spillspacelimit | text | The operator disk flushing space. |
useconfig | text[] | Session defaults for run-time configuration variables |
nodegroup | name | Name of the logical cluster associated with the user. If no logical cluster is associated, this column is left blank. |
Example¶
Query the current database user list.
SELECT usename FROM pg_user;
usename
-----------
dbadmin
u1
u2
u3
(4 rows)