Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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"

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group