在UPDATE中使用
delete (-) and concatenate (||) operators,例如：
原文链接：https://www.f2er.com/postgresql/192794.htmlcreate table example(id int primary key,js jsonb);
insert into example values
(1,'{"nme": "test"}'),(2,'{"nme": "second test"}');
update example
set js = js - 'nme' || jsonb_build_object('name',js->'nme')
where js ? 'nme'
returning *;
id | js
----+-------------------------
1 | {"name": "test"}
2 | {"name": "second test"}
(2 rows)
