List tables in all schemas (PostgreSQL)

14 May 2010

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;