On this page 
The SHOW USERS statement lists the users for all databases.
Synopsis
Required privileges
The user must have the SELECT privilege on the system table.
Example
> SHOW USERS;
user_name
+------------+
jpointsman
maxroach
root
(3 rows)
New in v19.2: Alternatively, within the built-in SQL shell, you can use the \du shell command:
> \du
user_name
+------------+
jpointsman
maxroach
root
(3 rows)
See also
Was this helpful?
