Re: JSON TO POSTGRE TABLE
От
Michael Paquier
Тема
Re: JSON TO POSTGRE TABLE
Дата
Msg-id
CAB7nPqTz4X53yZF61A5GpDHqROR5zTK_0NT7gh94f0horiXa4Q@mail.gmail.com
Ответ на
JSON TO POSTGRE TABLE (Kavi)
Список
Дерево обсуждения
JSON TO POSTGRE TABLE Kavi <kaviraj125@gmail.com>
Re: JSON TO POSTGRE TABLE Michael Paquier <michael.paquier@gmail.com>
Re: JSON TO POSTGRE TABLE Michael Paquier <michael.paquier@gmail.com>
Re: [SQL] JSON TO POSTGRE TABLE Shujie Shang <sshang@pivotal.io>
Re: [NOVICE] [SQL] JSON TO POSTGRE TABLE Felipe Santos <felipepts@gmail.com>
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 по дате отправления
