On 3/7/19 1:21 PM, github kran wrote:
Hello PostgreSQL Team,
Are there are any tools to migrate data present in the json files ? to
the postgreSQL database.
We have data in flat files about 2 billion records across multiple files.
1) What is the easiest way I can transfer this data to relational
database ?.
2) Any tools I can use ?. and any better ways do it ?
An older blog:
https://www.citusdata.com/blog/2013/05/30/run-sql-on-json-files-without-any-data-loads/
Not sure if all the parts still work or not.
Otherwise I could see using the JSON types and JSON functions built into
Postgres:
https://www.postgresql.org/docs/10/datatype-json.html
https://www.postgresql.org/docs/10/functions-json.html
Appreciate your help.
Thanks
Kran,
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
