---

SELECT
    table_schema,
    table_name,
    ordinal_position,
    column_name,
    data_type
FROM information_schema.columns
WHERE
      (
          table_schema = 'ourpension'
          AND table_name = 'application_death_info'
      )
   OR (
          table_schema = 'back_office'
          AND table_name IN ('operation', 'incoming_order')
          AND (
                 column_name ILIKE '%date%'
              OR column_name ILIKE '%time%'
          )
      )
   OR (
          table_schema = 'ourpension'
          AND (
                 column_name ILIKE '%family%'
              OR column_name ILIKE '%relative%'
              OR column_name ILIKE '%relation%'
              OR column_name ILIKE '%related%'
              OR column_name ILIKE '%close%'
          )
      )
ORDER BY
    table_schema,
    table_name,
    ordinal_position;