Re: importing a messy text file - Mailing list pgsql-general

From Michael Paquier
Subject Re: importing a messy text file
Date
Msg-id CAB7nPqSa9uBTS+W7-k89SRsfEEjM=zqH+mX4FqTSuYq=V97hag@mail.gmail.com
Whole thread Raw
In response to Re: importing a messy text file  (bricklen <bricklen@gmail.com>)
List pgsql-general
On Thu, May 1, 2014 at 1:30 AM, bricklen <bricklen@gmail.com> wrote:
>
> On Wed, Apr 30, 2014 at 1:07 AM, Willy-Bas Loos <willybas@gmail.com> wrote:
>>
>>
>> Hi,
>>
>> I have a 56GB textfile that i want to import into postgres.
>> The file is tab delimited and not quoted.
>
>
> Would Pgloader be an option? http://tapoueh.org/pgloader/
Or pg_bulkload? Contrary to the in-core COPY, it can filter
"incorrect" tuple data at the line level.
--
Michael


pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: WAL Replication + PITR
Next
From: Francisco Olarte
Date:
Subject: Re: Vacuuming strategy