postgres export data to csv with header in python code example

Example: postgresql export output table as a csv

COPY table_name TO 'file_name.csv' DELIMITER ',' CSV HEADER;