metadata

The suggested solution didn’t work for me with postgresql 9.1.4 this worked: SELECT dependent_ns.nspname as dependent_schema , dependent_view.relname as dependent_view , source_ns.nspname as source_schema , source_table.relname as source_table , pg_attribute.attname as column_name FROM pg_depend JOIN pg_rewrite ON pg_depend.objid = pg_rewrite.oid JOIN pg_class as dependent_view ON pg_rewrite.ev_class = dependent_view.oid JOIN pg_class as source_table ON pg_depend.refobjid = … Read more

select c.table_schema, c.table_name, c.column_name, pgd.description from pg_catalog.pg_statio_all_tables as st inner join pg_catalog.pg_description pgd on ( pgd.objoid = st.relid ) inner join information_schema.columns c on ( pgd.objsubid = c.ordinal_position and c.table_schema = st.schemaname and c.table_name = st.relname );