1. Using SQL Query To show the list of tables with the corresponding schema name, run this statement:
SELECT * FROM information_schema.tables;
or in a particular schema:
SELECT * FROM information_schema.tables WHERE table_schema = 'schema_name';
2. Using psql To list all tables: In all schemas:
\dt *.*
In a particular schema:
\dt schema_name.*