Обсуждение: BUG #6254: COPY ... TO .. CSV sometimes doesn't escape strings
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.
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. +