From the psql command-line interface,
To begin with, select your database
\c database_name
Then, this gives all the tables in the current schema:
\dt
Programmatically (or from the psql interface also, of course):
SELECT * FROM pg_catalog.pg_tables;
The system tables live in the pg_catalog database.
Join the SQL Training course now if you want to gain more knowledge in SQL.