Been working with PostgreSQL for over 6 years now, and honestly, for quick lookups during development, I just stay inside the psql terminal and use this:
psql mydb
\dt
It lists all tables in the current schema, super handy and instant. If I ever need to explore all schemas, then \dt .
does the trick. It’s my go-to for a fast postgres list tables check without writing any SQL.