List tables in all schemas (PostgreSQL)

From ben.goodacre.name/tech

Jump to: navigation, search

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;
Personal tools
Namespaces
Variants
Actions
Navigation
Toolbox