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

From Alberto Cabello Sánchez
Subject Re: importing a messy text file
Date
Msg-id 20140430101352.8ddca1584e36fd647bde7ce5@unex.es
Whole thread Raw
In response to importing a messy text file  (Willy-Bas Loos <willybas@gmail.com>)
List pgsql-general
On Wed, 30 Apr 2014 10:07:09 +0200
Willy-Bas Loos <willybas@gmail.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@unex.es>


pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: importing a messy text file
Next
From: Chris Travers
Date:
Subject: Re: Security Issues: Allowing Clients to Execute SQL in the Backend.