---

select
    c.table_schema,
    c.table_name,
    c.column_name,
    c.data_type,
    col_description(
        pc.oid,
        pa.attnum
    ) as column_comment
from information_schema.columns c
join pg_catalog.pg_namespace pn
    on pn.nspname = c.table_schema
join pg_catalog.pg_class pc
    on pc.relnamespace = pn.oid
   and pc.relname = c.table_name
join pg_catalog.pg_attribute pa
    on pa.attrelid = pc.oid
   and pa.attname = c.column_name
where (
       c.table_schema = 'ourpension'
       and c.table_name = 'eps'
       and c.column_name = 'classification'
)
or (
       c.table_schema = 'back_office'
       and c.table_name in (
           'eps_transaction',
           'report_conformity_pu_bu_detail'
       )
       and c.column_name in (
           'classification',
           'classification_id',
           'contract_class_code'
       )
)
order by c.table_schema, c.table_name, c.column_name;