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


SELECT
    field.key AS field_name,
    field.value AS field_value
FROM back_office.operation o
CROSS JOIN LATERAL
    jsonb_each_text(to_jsonb(o)) AS field
WHERE o.id = 84212555
  AND field.value IS NOT NULL
ORDER BY field.key;