Re: JSON TO POSTGRE TABLE
| От | Michael Paquier |
|---|---|
| Тема | Re: JSON TO POSTGRE TABLE |
| Дата | |
| Msg-id | CAB7nPqTz4X53yZF61A5GpDHqROR5zTK_0NT7gh94f0horiXa4Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | JSON TO POSTGRE TABLE (Kavi <kaviraj125@gmail.com>) |
| Ответы |
Re: JSON TO POSTGRE TABLE
Re: [SQL] JSON TO POSTGRE TABLE |
| Список | pgsql-general |
On Mon, Mar 30, 2015 at 6:54 PM, Kavi <kaviraj125@gmail.com> wrote:
JSON is a data type: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...
http://www.postgresql.org/docs/devel/static/datatype-json.html
So what you need to do is at least to create a table with a column having as data type JSON, and then insert data into it:
=# CREATE TABLE json_tab (data json);
CREATE TABLE
=# INSERT INTO json_tab VALUES ('{"key":"value","key2":"value2"}');
INSERT 0 1
=# select * from json_tab ;
data
---------------------------------
{"key":"value","key2":"value2"}
(1 row)
--
=# CREATE TABLE json_tab (data json);
CREATE TABLE
=# INSERT INTO json_tab VALUES ('{"key":"value","key2":"value2"}');
INSERT 0 1
=# select * from json_tab ;
data
---------------------------------
{"key":"value","key2":"value2"}
(1 row)
--
Michael
В списке pgsql-general по дате отправления: