Re: Plan for CSV handling of quotes, NULL - Mailing list pgsql-patches

From Richard Huxton
Subject Re: Plan for CSV handling of quotes, NULL
Date
Msg-id 200404160100.33368.richardh@archonet.com
Whole thread Raw
In response to Re: Plan for CSV handling of quotes, NULL  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Plan for CSV handling of quotes, NULL  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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

pgsql-patches by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Plan for CSV handling of quotes, NULL
Next
From: Bruce Momjian
Date:
Subject: Re: Plan for CSV handling of quotes, NULL