Added to TODO for COPY:
o Allow COPY in CSV mode to control whether "" is treated as NULL
http://archives.postgresql.org/pgsql-hackers/2007-07/msg00905.php
---
Andrew Dunstan wrote:
>
> [redirecting to -hac
* Tom Lane ([EMAIL PROTECTED]) wrote:
> Andrew Dunstan <[EMAIL PROTECTED]> writes:
> > ... Oh, and if we did allow the
> > quote char we should surely only allow it on input - just because other
> > programs produce absurd output there is not reason we should.
>
> Yeah. The *real* problem with
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> ... Oh, and if we did allow the
> quote char we should surely only allow it on input - just because other
> programs produce absurd output there is not reason we should.
Yeah. The *real* problem with the patch as proposed is that it allows a
COPY OUT
Tom Lane wrote:
Stephen Frost <[EMAIL PROTECTED]> writes:
Other, unrelated, options being or not being there doesn't really have
any bearing on this though. I'm not inventing new syntax here. I'm
just removing a restriction on what the user can do that doesn't need
to exist.
I don'
Stephen Frost <[EMAIL PROTECTED]> writes:
> Other, unrelated, options being or not being there doesn't really have
> any bearing on this though. I'm not inventing new syntax here. I'm
> just removing a restriction on what the user can do that doesn't need
> to exist.
I don't think you're "just r
* Andrew Dunstan ([EMAIL PROTECTED]) wrote:
> Stephen Frost wrote:
>> I'm honestly not a big fan of the "columnlist" approach that's been
>> taken with the options. While I understand the desire to seperate the
>> parsing from the typing, making the users essentially do that association
>> for us
Stephen Frost wrote:
I'm honestly not a big fan of the "columnlist" approach that's been
taken with the options. While I understand the desire to seperate the
parsing from the typing, making the users essentially do that association
for us by way of making them specify how to handle each colu
* Andrew Dunstan ([EMAIL PROTECTED]) wrote:
> This looks too clever by half, to me. Someone facing the problem you are
> facing would have to dig quite deep to find the solution you're promoting.
Oddly enough, it was one of the first things I tried when I discovered
it wasn't just realizing that
[redirecting to -hackers]
Stephen Frost wrote:
* Gregory Stark ([EMAIL PROTECTED]) wrote:
"Tom Lane" <[EMAIL PROTECTED]> writes:
Stephen Frost <[EMAIL PROTECTED]> writes:
Please find attached a minor patch to remove the constraints that a
user can't include the delimiter
