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

From VENKTESH GUTTEDAR
Subject Re: Appending new data to existing field of Json data type
Date
Msg-id CA+iwz4kw06A0LqcM_5Bvz61kBv6y_epdZpaVqocnDmRk6BHszA@mail.gmail.com
Whole thread Raw
In response to Re: Appending new data to existing field of Json data type  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Thanks Adrian Klaver, Its really helped me to solve my problem, ya i have
example_list = jsonfield.JSONField() in models. Apologies i did not mention that. but anyways thank again.

On Thu, Oct 30, 2014 at 8:09 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
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



--
Regards :
Venktesh Guttedar.

pgsql-general by date:

Previous
From: David G Johnston
Date:
Subject: Re: syntax error while using pg_dump in Postgres 8.4
Next
From: David G Johnston
Date:
Subject: Re: syntax error while using pg_dump in Postgres 8.4