How to modify field with jsonPath in PostgreSQL?

Question

Thanks!

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

dilshod · Accepted Answer · 2020-05-26 06:22:41Z

0

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

user330315

answered May 26, 2020 at 6:19

dilshod

891 silver badge3 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

That's not correct anymore since PostgreSQL 14, see this answer to a different question: stackoverflow.com/a/71794798/4300087