agora inbox for [email protected]  

help / color / mirror / Atom feed

From: Chris Spotts <[email protected]>
To: Josh Berkus <[email protected]>
Cc: Andrew Dunstan <[email protected]>
Cc: Itagaki Takahiro <[email protected]>
Cc: Jaime Casanova <[email protected]>
Cc: [email protected]
Subject: Re: COPY WITH CSV FORCE QUOTE *
Date: Thu, 16 Jul 2009 15:40:03 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>

Josh Berkus wrote:
> Andrew,
>
>> AFAICT on a brief look at the patch, it doesn't affect the quoting of
>> nulls on export, it just allows * as an alias for all columns for FORCE
>> QUOTE (as well as FORCE NOT NULL). But FORCE QUOTE has never forced
>> quoting of null values, only non-null values. We have never quoted null
>> values, and I'm fairly resistant to any suggestion that we should.
>
> See?  That's what happens when I can't build the docs.  ;-)  (and 
> there's no previous discussion of the feature).
>
>>
>> As for importing data from programs that produce all values in quotes
>> including null/missing values (your pro case above), arguably what we
>> need is another flag that would turn an empty string into a null.
>
> ooooh, TODO, please?  There's a lot of this out there, and I've had to 
> build sed into a lot of import routines.
>
+1 For that on the TODO, happens all the time...

view thread (22+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: COPY WITH CSV FORCE QUOTE *
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox