"mathieu.chappuis@msg-software.com" <mathieu.chappuis@msg-software.com> writes:
> test_db=> SELECT '+'||numtst||'+' AS "numtst", '*'||chartst||'-' AS "chartst" FROM test;
> numtst | chartst
> --------+------------
> -+2+ | *100/100
> -+4+ | *100/100
> -+5+ | *200/200
> (3 rows)
> As you see the last '-' in the second column is appended to the first column.
I think you have carriage returns in the values of chartst, which would
not be surprising if the original data file had Windows-style newlines
in it. COPY expects Unix-style newlines.
regards, tom lane