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
tic tac toe
test jsonb_set of PostgreSQL
prec
Full text search
nested array to table
Select the latest id from last week from each different contact without repeating barcodes.....
PostreSQL: Today's Date/Time
SQL Practice Sample: Movie Database
loggin_trigger-audit
lol