Export PostgreSQL database table header and data to CSV file

Introduction

From Adminer management tool it's has export to csv file option for mysql database But not available for postgresql database. Here I will show the command to export CSV for postgresql database.

copy from query

copy (select oid,relname from pg_class limit 5) to stdout;

Export PostgreSQL table to csv with header for some column(s)

COPY products(is_public, title, discount) TO 'D:\csv_backup\products_db.csv' DELIMITER ',' CSV HEADER;    

COPY categories(name) TO 'D:\csv_backup\categories_db.csv' DELIMITER ',' CSV HEADER;

Full table backup to csv with header

COPY products TO 'D:\csv_backup\products_db.csv' DELIMITER ',' CSV HEADER;    

COPY categories TO 'D:\csv_backup\categories_db.csv' DELIMITER ',' CSV HEADER;