[
https://issues.apache.org/jira/browse/CSV-208?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16658407#comment-16658407
]
Gary Gregory commented on CSV-208:
----------------------------------
The fix:
- Updates the Javadoc for {{org.apache.commons.csv.CSVFormat.POSTGRESQL_CSV}}
- Updates the escape character for
{{org.apache.commons.csv.CSVFormat.POSTGRESQL_CSV}} to a back slash.
> Cannot parse PostgreSQL CSV and Text formats
> --------------------------------------------
>
> Key: CSV-208
> URL: https://issues.apache.org/jira/browse/CSV-208
> Project: Commons CSV
> Issue Type: Bug
> Components: Parser
> Reporter: Gary Gregory
> Assignee: Gary Gregory
> Priority: Major
> Fix For: 1.7
>
> Attachments: CSVFormatTest.java
>
>
> 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}
> 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.
> {quote}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
