postgresql – export table to csv

COPY (SELECT * FROM "table_name") TO 'C:\Users\your_user_name\Desktop\test.csv' WITH CSV DELIMITER ',';