pq_query_showtables.htm

SELECT table_schema,table_name FROM information_schema.tables ORDER BY table_schema,table_name;