Depending on how your search order is configured it can be easier to simply list every table in every schema:

select schemaname,tablename from pg_tables;

Category:PostgreSQL