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

Re: Plan for CSV handling of quotes, NULL

From: "Andrew Dunstan" <andrew(at)dunslane(dot)net>
To: <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Plan for CSV handling of quotes, NULL
Date: 2004-04-15 09:32:52
Message-ID: 4312.24.211.141.25.1082021572.squirrel@www.dunslane.net (view raw or flat)
Thread:
Lists: pgsql-patches
Bruce Momjian said:
> Andrew Dunstan wrote:
>>
>> copy mytable to 'mydata.csv' csv force zipcode;
>>
>> seems OK to me. I'm all in favor of low-tecH solutions where
>> appropriate. ;-)
>
> Could we have FORCE just force quotes on all values, rather than
> allowing a list of columns to be specified?  Seems if you have a
> strange zipcode field, it would be easier to just do them all.
>

Then dates and numbers would be wrong. No all or nothing switch will work.

cheers

andrew



Responses

pgsql-patches by date

Next:From: Bruce MomjianDate: 2004-04-15 14:17:27
Subject: Re: Plan for CSV handling of quotes, NULL
Previous:From: Peter EisentrautDate: 2004-04-15 08:17:18
Subject: Re: Update french translation of the 7.4 branch

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