# shows system tables
postgres=# dS
# list databases
postgres=# l
# list tables
postgres=# d
# list users
postgres=# SELECT * FROM pg_user;
writing