jbdesbas/copy_json.sql

Created September 15, 2023 10:20

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/jbdesbas/4ab12859895df47636dad151b832fab2.js"></script>
Save jbdesbas/4ab12859895df47636dad151b832fab2 to your computer and use it in GitHub Desktop.

Download ZIP

psql copy json

Raw

copy_json.sql

\copy mytable from 'fichier.json' WITH csv quote e'\x01' delimiter e'\x02'

Author

jbdesbas commented Sep 15, 2023

http://adpgtech.blogspot.com/2014/09/importing-json-data.html?m=1

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