Re: importing a messy text file

[Rémi Cura <remi.cura@xxxxxxxxx>]

Hey,
with latest version 9.3 you can use a copy from with a programm as argument.

I had a similar problem (an extra space at the end of each line), so I used sed in a pipeline to remove it before feeding it to database.

You can use the unix | pipe for most of the stuff.

If you have an older version you can use the mkfifo command to "trick" postgres into believing he will copy from a file.

Cheers,
Rémi-C

2014-04-30 10:47 GMT+02:00 Willy-Bas Loos <willybas@xxxxxxxxx>:

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