Re: [GENERAL] JSON TO POSTGRE TABLE

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: [GENERAL] JSON TO POSTGRE TABLE
Дата
Msg-id CAB7nPqSuW=tFO_4W9qL=JH7F2My3nGwZ2-Cnz3m=M0OdobKR3Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] JSON TO POSTGRE TABLE  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-novice
Дерево обсуждения


On Mon, Mar 30, 2015 at 7:11 PM, Michael Paquier <michael.paquier@gmail.com> wrote:



On Mon, Mar 30, 2015 at 6:54 PM, Kavi <kaviraj125@gmail.com> wrote:

I sample data  as below-


{   "glossary": {       "title": "example glossary",	"GlossDiv": {           "title": "S",		"GlossList": {               "GlossEntry": {                   "ID": "SGML",				"SortAs": "SGML",				"GlossTerm": "Standard Generalized Markup Language",				"Acronym": "SGML",				"Abbrev": "ISO 8879:1986",				"GlossDef": {                       "para": "A meta-markup language, used to create markup languages such as DocBook.",					"GlossSeeAlso": ["GML", "XML"]                   },				"GlossSee": "markup"               }           }       }   }
}
how can i inerst these json data in postgre tables.
.ie I want to convert json into sql as per the field
This may have been better asked in pgsql-novice I guess...

Oh, it was the case. You should avoid cross-posting into several lists at the same time...
--
Michael

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