---

select
    a.attnum,
    a.attname as column_name,
    format_type(a.atttypid, a.atttypmod) as data_type
from pg_attribute a
join pg_class c
    on c.oid = a.attrelid
join pg_namespace n
    on n.oid = c.relnamespace
where n.nspname = 'ourpension'
  and c.relname = 'contracts_annulled'
  and a.attnum > 0
  and not a.attisdropped
order by a.attnum;