"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