commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gary Gregory (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CSV-208) Cannot parse PostgreSQL CSV and Text formats
Date Mon, 27 Mar 2017 20:06:41 GMT

     [ https://issues.apache.org/jira/browse/CSV-208?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Gary Gregory updated CSV-208:
-----------------------------
    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}
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}


  was:
Cannot parse PostgreSQL CSV and Text formats.

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

- 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}



> 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
>
> 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
(v6.3.15#6346)

Mime
View raw message