---

SELECT
    'dev' AS schema_name,
    to_jsonb(c) - 'command' AS command_details,
    c.command::text AS command_code
FROM dev.query_action_command c
WHERE c.command::text ILIKE '%pr_create_fin_oper_from_rops%'

UNION ALL

SELECT
    'dev_local' AS schema_name,
    to_jsonb(c) - 'command' AS command_details,
    c.command::text AS command_code
FROM dev_local.query_action_command c
WHERE c.command::text ILIKE '%pr_create_fin_oper_from_rops%';