Andrew Kerr wrote: > > The following bug has been logged online: > > Bug reference: 6254 > Logged by: Andrew Kerr > Email address: andrew.k...@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 <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
