Re: Appending new data to existing field of Json data type

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Appending new data to existing field of Json data type
Дата
Msg-id 54524DA7.6010202@aklaver.com
обсуждение исходный текст
Ответ на Re: Appending new data to existing field of Json data type  (VENKTESH GUTTEDAR <venkteshguttedar@gmail.com>)
Ответы Re: Appending new data to existing field of Json data type  (VENKTESH GUTTEDAR <venkteshguttedar@gmail.com>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Appending new data to existing field of Json data type
Следующее
От: David G Johnston
Дата:
Сообщение: Re: syntax error while using pg_dump in Postgres 8.4