Загрузка данных


SELECT
    table_schema,
    table_name,
    column_name,
    data_type
FROM information_schema.columns
WHERE table_schema = 'back_office'
  AND table_name IN (
      'operation',
      'ops_assignee_decision_payment'
  )
  AND (
      column_name ILIKE '%assignee%'
      OR column_name ILIKE '%decision%'
      OR column_name ILIKE '%operation%'
  )
ORDER BY table_name, ordinal_position;