Re: Tools to migrate data from Json files to PostgreSQL DB.

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(dot)klaver(at)aklaver(dot)com