Once you're logged into a Postgresql database using the psql client, issue this command at the psql prompt:

\dt

This will list all of the tables in the current database.