Re: unexpected data loaded into database when used COPY FROM

"jianggq@fujitsu.com" <jianggq@fujitsu.com> writes:
> When I used COPY FROM command on windows, I found that If the line data ends with a backslash and carriage
return/newlines(\r\n),COPYFROM mishandle the line . 
> As a result, there were unexpected data loaded into database.

If what you're saying is that backslash-\r-\n results in the \r being
taken as a data character, there is exactly nothing unexpected about that.

            regards, tom lane