Editing a jsonb value in postgresql?

Question

I have a jsonb column that stores values like this:

{"v":"0","c":"ACC",...}

I'd like to update some of the v values to 1

Is there any built-in function to do that in postgresql?

E: I'm using v9.6

[jsonb_set](https://www.postgresql.org/docs/current/static/functions-json.html) — , Sep 19 '17 at 08:37
@VaoTsun yes, I've updated the question. I want to change the values — Joshua Rajandiran, Sep 19 '17 at 09:13
Both suggestions (`jsob_set` and `||`) that [are documented in the manual](https://www.postgresql.org/docs/current/static/functions-json.html) will do what you want — , Sep 19 '17 at 09:16
wouldn't it be a duplicate of https://stackoverflow.com/questions/18209625/how-do-i-modify-fields-inside-the-new-postgresql-json-datatype — Vao Tsun, Sep 19 '17 at 09:51

score 1 · Accepted Answer · answered Sep 19 '17 at 09:43

1

With Postgresql 9.5

UPDATE test SET data = data - 'v' || '{"v":1}' WHERE data->>'c' = 'ACC';

OR

UPDATE test SET data = jsonb_set(data, '{v}', '1'::jsonb);

answered Sep 19 '17 at 09:43

Andreea Craciun

1 Answers1