---

select
    n.nspname as schema_name,
    c.relname as object_name,
    c.relkind
from pg_class c
join pg_namespace n
    on n.oid = c.relnamespace
where n.nspname = 'ourpension'
  and c.relname ilike '%annul%'
order by c.relname;