[CSV-208] Fix escape character for POSTGRESQL_TEXT and POSTGRESQL_CSV formats.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.7
• Component/s: Parser
• Assignee: Gary D. Gregory
• Reporter: Gary D. Gregory
• Created: 27/Mar/17 20:01
• Updated: 06/Jul/21 11:43
• Resolved: 20/Oct/18 15:51

Description

Cannot parse PostgreSQL CSV and Text formats.

We cannot seem to parse the stock PostgreSQL Text format, see

• org.apache.commons.csv.CSVPrinterTest.testRandomPostgreSqlCsv()
• org.apache.commons.csv.CSVPrinterTest.testRandomPostgreSqlText()
• org.apache.commons.csv.CSVPrinterTest.testPostgreSqlCsvNullOutput()
• org.apache.commons.csv.CSVPrinterTest.testPostgreSqlCsvTextOutput()

I am guessing that the issue is that in PostgreSQL, the escape character is the same as the quote character:

QUOTE
Specifies the quoting character to be used when a data value is quoted. The default is double-quote. This must be a single one-byte character. This option is allowed only when using CSV format.

ESCAPE
Specifies the character that should appear before a data character that matches the QUOTE value. The default is the same as the QUOTE value (so that the quoting character is doubled if it appears in the data). This must be a single one-byte character. This option is allowed only when using CSV format.

Issue Links

• is related to: CSV-207 Provide a CSV Format for printing PostgreSQL CSV and Text formats
• relates to: CSV-200 CSVFormat cannot read its own output if input contain escape character followed by quote character