How to get list of tables in PostgreSQL Database

We can get the list of tables by using the meta-command \dt or by using SQL statement.

Get the list of tables in current schema of PostgreSQL by using \dt:

Get the list of tables in PostgreSQL by using SQL statement:

SELECT * FROM information_schema.tables
WHERE table_schema NOT IN ('information_schema',
'pg_catalog');

or

select * from pg_catalog.pg_tables
where schemaname != 'information_schema' and schemaname != 'pg_catalog';

If we want to see schema tables

\dt schema_name.*