Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Replace key of json
create table form ( id integer, data json ); insert into form (id, data) values (1000, $$ {"formType": "DEFAULT", "old_key": {"column": [{"old_key": "1"}, {"old_key": "7"}, {"old_key": "22"}]}} $$::json ) ; SELECT * FROM form; UPDATE form set data = data::jsonb - 'old_key' || jsonb_build_object('new_key', data->'old_key') where data::jsonb ? 'old_key'; SELECT * FROM form;
run
|
edit
|
history
|
help
0
Atividade 2
1075-1077 Project Analysis
loggin_trigger-audit
quiz 1
Leetcode 569. Median Employee Salary
find null in any column of table using PostgreSQL
Assignment 1(SET A)
Descriptor test
arjun
Black Wall