This PostgreSQL extension implements functions to export/import JSON and XML from/to PostgreSQL #Tested 9.2+
IMPORTANT: There're bugs in the existing version, please contact to me.
Run: make install
In PostgreSQL database execute: CREATE EXTENSION jx_io;
It create schema jx_io
Example of use:
###export
select jx_io.export_json_table('/tmp/export_roles.json','pg_roles')--export table to json file
select jx_io.export_json_query('/tmp/export_databases.json','select * from pg_database')--export result of query to json file
select jx_io.export_xml_table('/tmp/export.xml','pg_database')--export table to xml file
select jx_io.export_xml_query('/tmp/export.xml','select * from pg_roles')--export result of query to xml file
###import
select jx_io.import_json_docs_into_table('/tmp/export.json','table_x','col1') --import json file (with one or many json docs) to column into table
select jx_io.import_json_doc('/tmp/doc.json')--return json doc from json file (on doc)
select jx_io.import_xml('/tmp/export.xml')--return xml doc from xml file
Anthony R. Sotolongo leon asotolongo@gmail.com