Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
renaming JSON field
create table liaison ( id integer, content jsonb ); insert into liaison (id, content) values (52056, $$ { "priority_id": "123", "urgent_problem_id": "1233" } $$::jsonb ) ; UPDATE liaison set content = content - 'urgent_problem_id' || jsonb_build_object('urgent_problem_ids', content->'urgent_problem_id') where content ? 'urgent_problem_id'; SELECT * FROM liaison;
run
|
edit
|
history
|
help
0
menu sample
How i can get the difference of closest two date in two table join in postgresql
testo
pgsql trigger 01 - Ovocie
Webiste SQL Analysis
PosgresSQL Sandbox: Legitimate Resale
array comparison
Attributvariation 2
3
1