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

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: github kran <githubkran(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Tools to migrate data from Json files to PostgreSQL DB.
Date: 2019-03-08 04:12:13
Message-ID: CAFj8pRDcjm2xZGZj8GOV7otBz8ist6dGX7NJcN2sXkGp3LM1Rg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

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

https://github.com/okbob/pgimportdoc

Regards

Pavel

> Appreciate your help.
>
>
> Thanks
> Kran,
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-03-08 06:12:25 Re: partial data migration
Previous Message Julie Nishimura 2019-03-08 03:54:23 Re: partial data migration