How to modify field with jsonPath in PostgreSQL?

Question

Thanks!

`jsonb_set()` https://www.postgresql.org/docs/current/functions-json.html — , May 25 '20 at 16:17
jsonb_set does not support jsonPath, it has a different path format — dilshod, May 25 '20 at 17:00
Well, that's the only way to modify a JSON value in Postgres. — , May 25 '20 at 18:09

score 1 · Answer 1 · edited May 26 '20 at 06:22

1

There are currently no ways to update JSON properties using JsonPath. The only way is with jsonb query jsonb_set

edited May 26 '20 at 06:22

answered May 26 '20 at 06:19

dilshod

1 Answers1