Re: Plan for CSV handling of quotes, NULL

From: Richard Huxton <richardh(at)archonet(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Plan for CSV handling of quotes, NULL
Date: 2004-04-16 00:00:33
Message-ID: 200404160100.33368.richardh@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

On Thursday 15 April 2004 15:58, Bruce Momjian wrote:
>
> OK, so we need a list of columns for output with quotes, and a list of
> columns where NULL should be changed to zero-length strings.
>
> How about if we use FORCE to force quotes on output, and CONVERT to
> convert null to zero-length strings on input?

How about FORCEQUOTES and NULLTOBLANK which tells you what they will do?

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2004-04-16 02:34:58 Re: Plan for CSV handling of quotes, NULL
Previous Message Andrew Dunstan 2004-04-15 15:08:49 Re: Plan for CSV handling of quotes, NULL