I read the documentation and built a command and tried it and got a syntax error.
Re-read the syntax and examples on this page. Your first problem, as noted by the error message, is that the word "to" does not immediately follow the word copy.
Before I ran the command, I changed all single quotes in the csv file to double quotes. I copied the command and the generated error onto my clipboard so what follows is a paste into this message. Cut here. copy to health /home/jude/health.csv format csv header force-not-null; ERROR: syntax error at or near "to" LINE 1: copy to health /home/jude/health.csv format csv header force...