Postgres Pro
Downloads
Home   >   mailing lists

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

From Pavel Stehule
Subject Re: Tools to migrate data from Json files to PostgreSQL DB.
Date
Msg-id CAFj8pRDcjm2xZGZj8GOV7otBz8ist6dGX7NJcN2sXkGp3LM1Rg@mail.gmail.com
Whole thread Raw
In response to Tools to migrate data from Json files to PostgreSQL DB.  (github kran <githubkran@gmail.com>)
List pgsql-general
Tree view
Hi

čt 7. 3. 2019 v 22:21 odesílatel github kran <githubkran@gmail.com> 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


Regards

Pavel


Appreciate your help.


Thanks
Kran,

pgsql-general by date:

Previous
From: Julie Nishimura
Date:
Subject: Re: partial data migration
Next
From: Adrian Klaver
Date:
Subject: Re: partial data migration