Re: unexpected data loaded into database when used COPY FROM - Mailing list pgsql-hackers

From Tom Lane
Subject Re: unexpected data loaded into database when used COPY FROM
Date
Msg-id 1837600.1625672046@sss.pgh.pa.us
Whole thread Raw
In response to unexpected data loaded into database when used COPY FROM  ("jianggq@fujitsu.com" <jianggq@fujitsu.com>)
List pgsql-hackers
"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



pgsql-hackers by date:

Previous
From: Domingo Alvarez Duarte
Date:
Subject: Re: PostgreSQL-13.3 parser.y with positional references by named references
Next
From: Alexander Pyhalov
Date:
Subject: Re: Case expression pushdown