How to modify field with jsonPath in PostgreSQL?

Question

How to modify a field using jsonPath in PostgreSQL like SQL Server JSON_MODIFY (https://learn.microsoft.com/en-us/sql/t-sql/functions/json-modify-transact-sql?view=sql-server-ver15)?

Thanks!

Answer 1

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