Re: COPY formatting

Joshua D. Drake wrote:

>>
>> And, BTW, I deal with CSV *all the time* for my insurance clients, 
>> and I can tell you that that format hasn't changed in 20 years.   We 
>> can hard-code it if it's easier.
>
>
> Well many of my clients consider CSV "Character Separated Value" not 
> Comma... Thus I get data like this:
>
> "Hello","Good Bye"
> Hello    Good Bye
> Hello,Good Bye
> "This", "They're"
> This    They're
> "This"    "Is"    "A"    1


*nod* I too have seen these and other variants over the years, including 
some that use single quote instead of double quote as the quote char, 
and \ as the escape char.

My suggested scheme for beefing up COPY was made with all these variants 
in mind.

cheers

andrew