---

SELECT
    a.id,
    to_jsonb(a) ->> 'code' AS action_code,
    to_jsonb(a) ->> 'name' AS action_name
FROM dev.query_action a
WHERE a.id = 34715;




SELECT
    table_schema,
    table_name,
    column_name
FROM information_schema.columns
WHERE table_schema IN ('dev', 'dev_local')
  AND data_type IN ('text', 'character varying', 'json', 'jsonb')
  AND (
      column_name ILIKE '%javascript%'
      OR column_name ILIKE '%content%'
      OR column_name IN ('js', 'java_script')
  )
ORDER BY table_schema, table_name, column_name;