jx_io

This Release
jx_io 0.1.1
Date
Status
Stable
Other Releases
Abstract
This PostgreSQL extension implements functions to export/import JSON ann XML from/to PostgreSQL
Description
This PostgreSQL extension implements functions to export/import JSON ann XML from/to PostgreSQL
Released By
anthony
License
PostgreSQL
Resources
Special Files
Tags

Extensions

jx_io 0.1.1
This PostgreSQL extension implements functions to export/import JSON ann XML from/to PostgreSQL

README

Contents

jx_io extension
======================================

This PostgreSQL extension implements  functions to export/import JSON ann XML from/to PostgreSQL
#Tested  9.2+

IMPORTANT: There're bugs in the existing version, please contact to me.


Building and install
--------
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