How to list all tables in psql?
If you wish to list all tables, you must use: \dt *.* to indicate that you want all tables in all schemas. This will include tables in pg_catalog, the system tables, and those in information_schema. There’s no built-in way to say “all tables in all user-defined schemas”; you can, however, set your search_path to a …