This is one of the few cases where you don't use "delimiters to delimit the delimiter"
CopyTo .. DELIMITEDwith ,
>After all these years I still forget: how to create a comma delimited file from a table. I just want the fields seperated with commas, no quotes. COPY TO ... DELIMITED WITH ???