COPY FROM erroring on \r \n

[vbMonk]

I'm trying to copy a text file into a table. The copy command fails on the first record and I believe it's because it's trying to copy the \r\n characters at the end of each line. Is there a way to copy the file and exclude these special characters? To strip them out of the file itself?

 

[feherke]

Hi

I think the record separator is the given operating system's end-of-line mark. No idea if can be modified.

I would simply remove the [tt]\r[/tt] characters from the line end. For example on Linux using GNU [tt]sed[/tt] :

sed -i 's/\r$//' thefile.sql

But there are special little tools for end-of-line mark conversion on each operating system.

Feherke.

http://rootshell.be/~feherke/

 

[vbMonk]

Thanks. The sed command worked.