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

Re: COPY WITH CSV FORCE QUOTE *

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: COPY WITH CSV FORCE QUOTE *
Date: 2009-07-20 23:42:23
Message-ID: 4A6500DF.9080602@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackers

Josh Berkus wrote:
> 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?
>

See previous thread on -patches/-hackers "allow CSV quote in NULL" in 
July 2007.

Quite apart from any other objection, doing what you suggest will not be 
column-by-column, like what I suggested. It's an all or nothing deal.

cheers

andrew

In response to

pgsql-hackers by date

Next:From: KaiGai KoheiDate: 2009-07-21 00:40:20
Subject: Re: [PATCH] SE-PgSQL/tiny rev.2193
Previous:From: Josh BerkusDate: 2009-07-20 23:41:32
Subject: Re: [PATCH] SE-PgSQL/tiny rev.2193

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