From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
---|---|
To: | Kavi <kaviraj125(at)gmail(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org, PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: JSON TO POSTGRE TABLE |
Date: | 2015-03-30 10:13:11 |
Message-ID: | CAB7nPqSuW=tFO_4W9qL=JH7F2My3nGwZ2-Cnz3m=M0OdobKR3Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice pgsql-sql |
On Mon, Mar 30, 2015 at 7:11 PM, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
wrote:
>
>
>
> On Mon, Mar 30, 2015 at 6:54 PM, Kavi <kaviraj125(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Shujie Shang | 2015-03-30 10:20:07 | Re: [SQL] JSON TO POSTGRE TABLE |
Previous Message | Michael Paquier | 2015-03-30 10:11:47 | Re: [GENERAL] JSON TO POSTGRE TABLE |
From | Date | Subject | |
---|---|---|---|
Next Message | Shujie Shang | 2015-03-30 10:20:07 | Re: [SQL] JSON TO POSTGRE TABLE |
Previous Message | Michael Paquier | 2015-03-30 10:11:47 | Re: [GENERAL] JSON TO POSTGRE TABLE |
From | Date | Subject | |
---|---|---|---|
Next Message | Shujie Shang | 2015-03-30 10:20:07 | Re: [SQL] JSON TO POSTGRE TABLE |
Previous Message | Michael Paquier | 2015-03-30 10:11:47 | Re: [GENERAL] JSON TO POSTGRE TABLE |