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