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

Re: allow CSV quote in NULL

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Stephen Frost" <sfrost(at)snowman(dot)net>, <pgsql-patches(at)postgresql(dot)org>
Subject: Re: allow CSV quote in NULL
Date: 2007-07-27 09:22:42
Message-ID: 87vec6p5el.fsf@oxford.xeocode.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> Stephen Frost <sfrost(at)snowman(dot)net> writes:
>>   Please find attached a minor patch to remove the constraints that a
>>   user can't include the delimiter or quote characters in a 'NULL AS'
>>   string when importing CSV files.
>
> This can't really be sane can it?

Including unquoted delimiter characters seems kind of insane. But including
the quote characters or quoted delimiter characters seems reasonable. 

The alternative would be interpreting NULL strings after dequoting but that
would leave no way to include the NULL string literally. This solution means
there's no way to include it (if it needs quoting) but only when you specify
it this way.

-- 
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com


In response to

Responses

pgsql-hackers by date

Next:From: Stephen FrostDate: 2007-07-27 11:38:47
Subject: Re: allow CSV quote in NULL
Previous:From: Dave PageDate: 2007-07-27 09:15:38
Subject: Re: stats_block_level

pgsql-patches by date

Next:From: Stephen FrostDate: 2007-07-27 11:38:47
Subject: Re: allow CSV quote in NULL
Previous:From: Stephen FrostDate: 2007-07-27 05:03:27
Subject: Re: allow CSV quote in NULL

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