SQL> select * from pg_catalog.pg_user;
usename | usesysid | usecreatedb | usesuper | usecatupd | userepl | passwd | valuntil | useconfig
----------------+----------+-------------+----------+-----------+---------+----------+----------+-----------
postgres | 10 | t | t | t | t | ******** | <NULL> | <NULL>
orascope_repo | 24585 | f | t | t | f | ******** | infinity | <NULL>
scott | 102622 | f | f | f | f | ******** | <NULL> | <NULL>
(4 rows)
Time: 0.590 ms
postgres@[local]:5432:postgres]
SQL> \du
List of roles
Role name | Attributes | Member of
----------------+------------------------------------------------+-----------
orascope_repo | Superuser +| {}
| Password valid until infinity |
postgres | Superuser, Create role, Create DB, Replication | {}
scott | | {}
postgres@[local]:5432:postgres]
SQL>
