PostgreSQL - How to Export Table to CSV file with header?

Export Table to CSV file with header in PostgreSQL

Using psql

\copy table_name to 'filename.csv’ csv header

Using SQL Query

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