Re: Appending new data to existing field of Json data type - Mailing list pgsql-general

On 10/29/2014 11:26 PM, VENKTESH GUTTEDAR wrote:

@Adrian Klaver, Thanks for this idea but still m really confused with
how to update the json filed in the DB. is there any way to update the
json field in the DB through view.?

Realized I should have shown at least one concrete example so, assuming you are dealing with Python data structures where:

id2.example_list = {"abc" : [ { "a":"b","c":"d" } ] }

then

id2.example_list["abc"].append({ "e":"f", "g":"h" })

id2.example_list

{'abc': [{'a': 'b', 'c': 'd'}, {'e': 'f', 'g': 'h'}]}


then

Regards :
Venktesh Guttedar.

--
Adrian Klaver
adrian.klaver@aklaver.com