how to select all tables in postgres code example
Example 1: get all tables postgres
SELECT * FROM pg_catalog.pg_tables;
Example 2: show all tables postgres
\dt
# show list of tables in postgres
SELECT * FROM pg_catalog.pg_tables;
\dt
# show list of tables in postgres