---

select
    table_schema,
    table_name,
    column_name,
    data_type
from information_schema.columns
where table_schema = 'ourpension'
  and (
        lower(table_name) like '%agreement%'
        or lower(table_name) like '%npo%'
      )
  and (
        lower(column_name) like '%1c%'
        or lower(column_name) like '%external%'
        or lower(column_name) like '%source%'
      )
order by table_name, column_name;