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=#