PostgreSQL
51.93. pg_user
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 51.94. pg_user Columns
| Name | Type | Description |
|---|---|---|
|
|
User name |
|
|
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 |
+
| Prev | Up | Next |
|---|---|---|
51.92. |
51.94. |
Submit correction
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.
Copyright © 1996-2023 The PostgreSQL Global Development Group