Andrew Kerr wrote:
> The following bug has been logged online:
> Bug reference: 6254
> Logged by: Andrew Kerr
> Email address: andrew(dot)kerr(at)unrulymedia(dot)com
> PostgreSQL version: 9.0.5
> Operating system: CentOS 5.4
> Description: COPY ... TO .. CSV sometimes doesn't escape strings
> Query of this form:
> copy (select
> 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(at)momjian(dot)us> http://momjian.us
+ It's impossible for everything to be true. +
In response to
pgsql-bugs by date
|Next:||From: Bruce Momjian||Date: 2011-10-14 01:37:03|
|Subject: Re: Re: BUG #6050: Dump and restore of view after a
schema change: can't restore the view|
|Previous:||From: Bruce Momjian||Date: 2011-10-13 17:09:07|
|Subject: Re: [BUGS] BUG #6034: pg_upgrade fails when it