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;