SELECT * FROM information_schema.tables WHERE table_schema = 'public'
SELECT * FROM pg_catalog.pg_tables;
dt schema_name.*
=> dt *.*
=> dt public.*