It is out of scope to document the full functionality of Postgres to add information about Postgres. Table information is given in the following terminal dump.
#su postgres
#psql dcache
Welcome to psql 7.3.8-RH, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
dcache=# \dt
List of relations
Schema | Name | Type | Owner
--------+-------------------------+-------+-----------
public | copyfilerequests | table | srmdcache
public | copyfilerequests_b | table | srmdcache
public | copyrequests | table | srmdcache
public | copyrequests_b | table | srmdcache
public | getfilerequests | table | srmdcache
public | getfilerequests_b | table | srmdcache
public | getrequests | table | srmdcache
public | getrequests_b | table | srmdcache
public | getrequests_protocols | table | srmdcache
public | getrequests_protocols_b | table | srmdcache
public | pinrequests | table | srmdcache
public | pins | table | srmdcache
public | putfilerequests | table | srmdcache
public | putfilerequests_b | table | srmdcache
public | putrequests | table | srmdcache
public | putrequests_b | table | srmdcache
public | putrequests_protocols | table | srmdcache
public | putrequests_protocols_b | table | srmdcache
public | srmnextrequestid | table | srmdcache
public | srmrequestcredentials | table | srmdcache
(20 rows)
dcache=#