Re: JSON TO POSTGRE TABLE

[Michael Paquier <michael.paquier@xxxxxxxxx>]

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

On Mon, Mar 30, 2015 at 6:54 PM, Kavi <kaviraj125@xxxxxxxxx> 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