How to add element to json array in PostgreSQL 9.3?

Question

PostgreSQL

Hello.
There is a field in the table with json type. There is always an array of objects. It is necessary to add one more element to this array in one update, that is, without reading the row from the table in advance.
Didn't find a solution. Most likely, the fact is that in json in general there will not always be an array of objects.
I can’t use json[] for reasons that doctrine is not friendly with this type.
Well, or you need to teach doctrine to understand this type :)

Answer 1

If done purely by postgres, then either update the entire field, or use a function to update, for example, like this .