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


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