Re: Tools to migrate data from Json files to PostgreSQL DB. - Mailing list pgsql-general

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@aklaver.com