I need to copy table data into text file on Windows in csv format. How to do that?
What I have tried:
COPY test TO '"E:\\test.csv"' DELIMITER ',' CSV HEADER;
I am receiving an error while executing this query. That test.csv
file have to create first before copying data into that.
ERROR: relative path not allowed for COPY to file SQL state: 42602