Re: allow CSV quote in NULL - Mailing list pgsql-patches

From Gregory Stark
Subject Re: allow CSV quote in NULL
Date
Msg-id 87vec6p5el.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: allow CSV quote in NULL  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: allow CSV quote in NULL
List pgsql-patches
"Tom Lane" <tgl@sss.pgh.pa.us> writes:

> Stephen Frost <sfrost@snowman.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


pgsql-patches by date:

Previous
From: Stephen Frost
Date:
Subject: Re: allow CSV quote in NULL
Next
From: Stephen Frost
Date:
Subject: Re: allow CSV quote in NULL