BUG #6148: unterminated CSV quoted field

From: "william wei" <wei_jieyun(at)founder(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6148: unterminated CSV quoted field
Date: 2011-08-04 07:48:15
Message-ID: 201108040748.p747mFSN037920@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 6148
Logged by: william wei
Email address: wei_jieyun(at)founder(dot)com
PostgreSQL version: 8
Operating system: linux
Description: unterminated CSV quoted field
Details:

error: unterminated CSV quoted field. when import CSV file.

copy command:
COPY tablename FROM '/tmp/test.cvs' csv DELIMITER AS ',' NULL AS '' QUOTE AS
'"';

CVS file content: (error when value contains \")
"value1 \" text ","value2","value3"

Browse pgsql-bugs by date

  From Date Subject
Next Message blammo72 2011-08-04 09:31:36 Re: BUG #6120: Problem running post-install step in Mac OS X Lion (GM)
Previous Message simonrodan 2011-08-04 04:26:31 Re: BUG #6120: Problem running post-install step in Mac OS X Lion (GM)