Re: allow CSV quote in NULL

"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