Postgres Pro
Downloads
Home   >   mailing lists

Thread: BUG #6254: COPY ... TO .. CSV sometimes doesn't escape strings

BUG #6254: COPY ... TO .. CSV sometimes doesn't escape strings

From
"Andrew Kerr"
Date:
The following bug has been logged online:

Bug reference:      6254
Logged by:          Andrew Kerr
Email address:      andrew.kerr@unrulymedia.com
PostgreSQL version: 9.0.5
Operating system:   CentOS 5.4
Description:        COPY ... TO .. CSV sometimes doesn't escape strings
Details:

Query of this form:

copy (select
 col1,col2
from mytable)
 to 'output.csv' with (format csv, force_quote *);

where some selected columns are text sometimes fails to escape quotes (with
another quote) in text.

On which rows this happens varies with different runs.

Sometimes a field will have some quotes escaped and some not.

Running on a 90 million row table.

Re: BUG #6254: COPY ... TO .. CSV sometimes doesn't escape strings

From
Bruce Momjian
Date:
Andrew Kerr wrote:
>
> The following bug has been logged online:
>
> Bug reference:      6254
> Logged by:          Andrew Kerr
> Email address:      andrew.kerr@unrulymedia.com
> PostgreSQL version: 9.0.5
> Operating system:   CentOS 5.4
> Description:        COPY ... TO .. CSV sometimes doesn't escape strings
> Details:
>
> Query of this form:
>
> copy (select
>  col1,col2
> from mytable)
>  to 'output.csv' with (format csv, force_quote *);
>
> where some selected columns are text sometimes fails to escape quotes (with
> another quote) in text.
>
> On which rows this happens varies with different runs.
>
> Sometimes a field will have some quotes escaped and some not.
>
> Running on a 90 million row table.

Please show us an example.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +