It has to be Excel csv file, this is the request from the client :(
>>I create an Excel output from table:
>>
>>
>>COPY to 'my_csv' csv
>>
>>
>>the problem is I always have the field name on the worksheet
>>
>>Code
>>10001
>>10002
>>
>>how can I eliminate the field name, so the output will be:
>>
>>10001
>>10002
>
>You could experiment with other output types such as SDF, DELIMITED etc. If you give the file a .txt extension Excel will be able to open it.