Re: importing a messy text file

From: Willy-Bas Loos <willybas(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: importing a messy text file
Date: 2014-04-30 08:47:12
Message-ID: CAHnozTgj4uk-vwFsqBLN142f-e1mWq519ecWfHTtayXw8FAO_Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alberto, it would be hard to use sed( s/^I$// ), because there is no
explicit NULL value and there are many NULLs in the last column.
So i can't be sure how many tabs should be in the end of each line.

Yes, Karsten, maybe scripting would be the easiest way to fix this, i would
then probably insert this line for line. That's a possibility. It might
take a long time to run, but that's not much of an issue.

--
Willy-Bas Loos

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Noel 2014-04-30 08:50:27 Re: SQL query runs fine on one platform (FreeBSD), but hangs on another (Windows)
Previous Message David Noel 2014-04-30 08:46:44 Re: SQL query runs fine on one platform (FreeBSD), but hangs on another (Windows)