SELECT * FROM pg_catalog.pg_tables;
PostgreSQL show tables command \dt
SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' ORDER BY table_name;