pgsql 更新json数据

update "pce"."p_ttl_data" set val=jsonb_set(val::jsonb,'{AWARDING_STATUS_APPROVAL_STATUS,val}','"Conditional approved"')
WHERE val -> 'AWARDING_STATUS_APPROVAL_STATUS' ->> 'val' = 'Conditional approve'

posted @ 2023-05-18 18:13  一杯清茶一本书  阅读(213)  评论(0编辑  收藏  举报