| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | VENKTESH GUTTEDAR <venkteshguttedar(at)gmail(dot)com> |
| Cc: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Appending new data to existing field of Json data type |
| Date: | 2014-10-30 14:39:35 |
| Message-ID: | 54524DA7.6010202@aklaver.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G Johnston | 2014-10-30 16:52:39 | Re: syntax error while using pg_dump in Postgres 8.4 |
| Previous Message | Adrian Klaver | 2014-10-30 14:21:49 | Re: Appending new data to existing field of Json data type |