BUG #3956: COPY FROM doesn't parse file correctly
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.
"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