Re: COPY for CSV documentation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>, pgsql-patches(at)postgresql(dot)org
Subject: Re: COPY for CSV documentation
Date: 2004-04-12 12:38:19
Message-ID: 8705.1081773499@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Bruno Wolff III <bruno(at)wolff(dot)to> writes:
> On Mon, Apr 12, 2004 at 02:26:14 -0400,
> Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:
>> a few points:
>> . in CSV mode, NULL should default to '' - that was in what I sent in.

> Postgres normally treats an empty string as an empty string. Are you sure
> you really want it to be treated as a NULL by default in this one place?

I think that's a spectacularly bad idea too. People who really want
that can write "NULL ''", but it shouldn't be implied by CSV mode.

regards, tom lane

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2004-04-12 13:34:23 Re: Information/schema hiding...
Previous Message Bruno Wolff III 2004-04-12 12:36:39 Re: COPY for CSV documentation