Updated on 2023-12-29 GMT+08:00

PG_USER

PG_USER displays information about users who can access the database.

Table 1 PG_USER columns

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.

1
2
3
4
5
6
7
8
SELECT usename  FROM pg_user;
  usename
-----------
 dbadmin
 u1
 u2
 u3
(4 rows)