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

[Pavel Stehule <pavel.stehule@xxxxxxxxx>]

Hi

čt 7. 3. 2019 v 22:21 odesílatel github kran <githubkran@xxxxxxxxx> napsal:

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 ?

I wrote pgimportdoc

https://github.com/okbob/pgimportdoc

Regards

Pavel

Appreciate your help.

Thanks

Kran,