SELECT * FROM information schema.tables;

SELECT * FROM information_schema.tables; 

SELECT * FROM information_schema.tables WHERE table_schema = 'schema_name';

\dt

Activities

• Read https://sqlblog.org/2011/11/03/the-case-against-information_schema-views

See also

• PostgreSQL: psql, .psqlrc, .pgpass, $HOME/.pg service.conf, -U, -W, -d, meta-commands: \du, \dg, \ddp, \dp, \list, \dn, \dt, \c, \l, \di, \q, show users, show, su - postgres, psql -c, \?, \connect, --version, --help, PL/pgSQL
• SQL, NewSQL: GraphQL (2015), SQLite, select, insert, select count, Distributed SQL, TablePlus, Cache hit ratio, pg_stat_user_tables, EXPLAIN, Index (PostgreSQL), DDL, SQL/MED, Group by, List users, SQL Injection, SQLAlchemy, CREATE USER, CREATE ROLE, EXPLAIN, ALTER DATABASE, REVOKE, NOLOCK, NOWAIT, EXISTS, Unique constraint

https://tableplus.com/blog/2018/04/postgresql-how-to-list-all-tables.html