Re: importing a messy text file

From: Alberto Cabello Sánchez <alberto(at)unex(dot)es>
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 08:13:52
Message-ID: 20140430101352.8ddca1584e36fd647bde7ce5@unex.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 30 Apr 2014 10:07:09 +0200
Willy-Bas Loos <willybas(at)gmail(dot)com> wrote:

> Hi,
>
> I have a 56GB textfile that i want to import into postgres.

!!!

> The problem is this:
> There is a tab after the last column, in many but not all records.

You could clean it up with something like s/^I$// , don't you?

--
Alberto Cabello Sánchez
<alberto(at)unex(dot)es>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2014-04-30 08:38:20 Re: Security Issues: Allowing Clients to Execute SQL in the Backend.
Previous Message Karsten Hilbert 2014-04-30 08:13:49 Re: importing a messy text file