---

SELECT
    table_schema,
    table_name,
    column_name,
    data_type
FROM information_schema.columns
WHERE table_schema IN ('robot', 'smev')
  AND (
      column_name ILIKE '%service%'
      OR column_name ILIKE '%folder%'
      OR column_name ILIKE '%path%'
  )
ORDER BY table_schema, table_name, ordinal_position;