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

From Willy-Bas Loos
Subject Re: importing a messy text file
Date
Msg-id CAHnozTgj4uk-vwFsqBLN142f-e1mWq519ecWfHTtayXw8FAO_Q@mail.gmail.com
Whole thread Raw
In response to Re: importing a messy text file  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Re: importing a messy text file  (Alberto Cabello Sánchez <alberto@unex.es>)
Re: importing a messy text file  (Rémi Cura <remi.cura@gmail.com>)
List 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

pgsql-general by date:

Previous
From: David Noel
Date:
Subject: Re: SQL query runs fine on one platform (FreeBSD), but hangs on another (Windows)
Next
From: David Noel
Date:
Subject: Re: SQL query runs fine on one platform (FreeBSD), but hangs on another (Windows)