Thread: BUG #3956: COPY FROM doesn't parse file correctly

BUG #3956: COPY FROM doesn't parse file correctly

From
"Maxim Ivanov"
Date:
The following bug has been logged online:

Bug reference:      3956
Logged by:          Maxim Ivanov
Email address:      ivanov.maxim@gmail.com
PostgreSQL version: 8.2.6
Operating system:   Fedora i386
Description:        COPY FROM doesn't parse file correctly
Details:

COPY FROM couldn't parse file correctly. "\" symbol escapes delimeter. So
string(spaces are tabulation symbols)
11111 AAAAAA BBBBB\ CCCCCC
would be recognized as three field string instead of 4 field.

Re: BUG #3956: COPY FROM doesn't parse file correctly

From
Tom Lane
Date:
"Maxim Ivanov" <ivanov.maxim@gmail.com> writes:
> COPY FROM couldn't parse file correctly. "\" symbol escapes delimeter. So
> string(spaces are tabulation symbols)
> 11111 AAAAAA BBBBB\ CCCCCC
> would be recognized as three field string instead of 4 field.

Sounds perfectly correct to me.  What were you expecting?

            regards, tom lane