COPY (SELECT * FROM view_name) TO 'output.csv' (HEADER, DELIMITER ',');