Re: Importing a Large .ndjson file

From: Sankar P <sankar(dot)curiosity(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Importing a Large .ndjson file
Date: 2020-06-18 07:46:43
Message-ID: CAMSEaH4M1v_umOP=H-rOmW=oLkHYRFuZ9Ed11-TeqOeGxX8V5A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> It looks like plain old COPY would do this just fine, along the lines
> of (in psql)
>
> \copy myTable(content) from 'myfile.ndjson'
>

Indeed. Thanks.

--
Sankar P
http://psankar.blogspot.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sankar P 2020-06-18 08:44:35 Using postgresql and JSONB on very large datasets
Previous Message Matthias Apitz 2020-06-18 07:13:55 Re: ESQL/C no indicator variables ./. error -213