PostgreSQL

\l                # List all databases
\c <db_name>      # Connect to a certain database
\dt               # List tables in the current database (using search_path)
\dt *.            # Same, but ignores search_path
\d+ <table_name>  # Show schema of the table with table_name.