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

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 (view raw or flat)
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

pgsql-patches by date

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

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