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

Re: COPY WITH CSV FORCE QUOTE *

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: COPY WITH CSV FORCE QUOTE *
Date: 2009-07-20 23:20:04
Message-ID: 4A64FBA4.4050802@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On 7/16/09 1:55 PM, Andrew Dunstan wrote:
> Well, somebody had better suggest a syntax for it, preferably without
> adding yet another keyword.

Actually, all that needs to happen is for NULL AS to accept '""' as a 
string.  Right now that produces:

ERROR:  CSV quote character must not appear in the NULL specification

What's the issue with that?  I can see how NULL AS '"' would break 
things, but if I wanted NULL AS '"Josh"' shouldn't I be able to have it?

-- 
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com

In response to

Responses

pgsql-hackers by date

Next:From: KaiGai KoheiDate: 2009-07-20 23:35:38
Subject: Re: [PATCH] SE-PgSQL/tiny rev.2193
Previous:From: Tom LaneDate: 2009-07-20 23:07:40
Subject: Re: [PATCH v4] Avoid manual shift-and-test logic in AllocSetFreeIndex

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