I need to create a non-quoted tab delimited file that has the column names as the header row. I tried using COPY TO output.filename DELIMTED WITH TAB but that puts quote marks around character fields and has no header row.

I know I can write my own code to handle this but is there some option settings in the COPY TO that can handle this directly?