>This gets rid of the dang double quote problem....
>
>COPY to myfile.csv delimited with "" with character '|'
>
>...if you do that command it creates a file without those stupid quote marks, delimited with the pipe symbol.
>
>...Sorry I was late to the game here I didn't notice the thread till just now - but perhaps this can help you out now or in the future. This is one quirk that got me stuck in the past.
Victor,
I couldn't understand how this would solve the problem. Wouldn't it be a new and more serious problem in itself? If for a second you think it could work, what would happen to a field that contains | ? Or a field with comma, apostrophe, tilde ... in it? Or one with date time data? I would repeat my warning that trying to transfer data to Excel using text is asking for trouble (unless that text is a well known data interchange format, say, XML).