JSON TO POSTGRE TABLE

From: Kavi <kaviraj125(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: JSON TO POSTGRE TABLE
Date: 2015-03-30 09:54:25
Message-ID: CANj80ecu_H52i4bW_YONFxZ4HyxKtqJGzH=WZAKTBOx9btdxTA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice pgsql-sql

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

--
Thanking You
Regards
Mr.Kavi R. Pachkawade

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2015-03-30 10:03:21 Re: pgadmin3 installation on Oracle Linux 6.6 64-bit ?
Previous Message Tim Clarke 2015-03-30 09:22:53 Re: Link Office Word form document with data from PostgreSQL

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Paquier 2015-03-30 10:11:47 Re: [GENERAL] JSON TO POSTGRE TABLE
Previous Message Tim Clarke 2015-03-30 09:22:53 Re: Link Office Word form document with data from PostgreSQL

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Paquier 2015-03-30 10:11:47 Re: [GENERAL] JSON TO POSTGRE TABLE
Previous Message Tim Clarke 2015-03-30 09:22:53 Re: Link Office Word form document with data from PostgreSQL