---

BEGIN;

UPDATE smev.smev_report_post_processes
SET
    id_process = 2,
    load_id_var =
        '{"(fileId,Integer,step=1+file_id)"}'
        ::smev."_ctx_var"
WHERE id_etl = 27
  AND id_loader = 0
  AND version_ex = 0
  AND id_process = 1
  AND load_post_process = 'PdyJgUIN'
  AND active = false;

INSERT INTO smev.smev_report_post_processes (
    id_etl,
    id_loader,
    version_ex,
    id_process,
    process_type,
    load_id_var,
    load_post_process,
    process_description,
    active
)
VALUES (
    27,
    0,
    0,
    1,
    1,
    '{"(query_datasource_code,String,a33r8zRX)"}'
        ::smev."_ctx_var",
    'm3hA3wRW',
    'Получение ID загруженного файла СНВ',
    false
);

COMMIT;






SELECT
    id_process,
    process_type,
    load_post_process,
    to_jsonb(load_id_var) AS parameters,
    active
FROM smev.smev_report_post_processes
WHERE id_etl = 27
  AND id_loader = 0
  AND version_ex = 0
ORDER BY id_process;