guoweihua1982

-- show all tables and columns and type definitions
SELECT s.schemaname,s.relname,a.attname,format_type(a.atttypid, a.atttypmod)
FROM pg_attribute a
INNER JOIN pg_stat_user_tables s ON s.relid = a.attrelid 
WHERE a.attnum > 0
ORDER BY 1,2,3