\l: List databases
\c <database>: Connect to a database
\d <table>: Show table definition
\d+ <table>: More detailed table definition
\di: List indexes
\di+: List indexes with additional information