tym-xqo/psql2json.sh

Last active August 29, 2015 14:24

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/tym-xqo/44caba93ca6f91e2765c.js"></script>
Save tym-xqo/44caba93ca6f91e2765c to your computer and use it in GitHub Desktop.

Download ZIP

Export table to json

Raw

psql2json.sh

	psql -h qa.iadops.com -p 5433 -U<username> \
	-c "select row_to_json(<table>) from <table>;" \
	-d oao_trial -At > <table>.json

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment