Try:
COPY TO ... DELIMITED WITH "" WITH CHARACTER TAB

>I have a table that I need to output to a text file. The data needs to be delimited with tab and no quotes around the data.
>
>The command, COPY TO myfile.txt DELIMITED WITH TAB, works except that the data is surrounded by quotes. The following works except that the data is surrounded by the underscore, COPY TO myfile.txt DELIMITED WITH _ WITH CHARACTER TAB.
>
>How can I output my data with each column delimted with only a TAB and no other character?
>
>Thanks,
>
>Jerry