Re: importing a messy text file

From: bricklen <bricklen(at)gmail(dot)com>
To: Willy-Bas Loos <willybas(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: importing a messy text file
Date: 2014-04-30 16:30:11
Message-ID: CAGrpgQ974_dH3wArM-umAiDyUjSOO4KU7SsR099xcXXr-22a=A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Apr 30, 2014 at 1:07 AM, Willy-Bas Loos <willybas(at)gmail(dot)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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G Johnston 2014-04-30 16:32:22 Re: Escape double-quotes in text[]?
Previous Message Raymond O'Donnell 2014-04-30 16:27:42 Re: Escape double-quotes in text[]?