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 |
parentid |
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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.