How to export data to a CSV file from a postgres database together with table headings?

Question: How to export data to a CSV file from a postgres database together with table headings?

Answer: 

1. Type in the following command in postgres using the command line:
   copy products to '/home/user/products.csv' delimiters ',' CSV HEADER
   
   • products = (Database Table)
   • '/home/user/products.csv' = (Location where to save the csv file)
   • You need to have write permissions to write the file to the filesystem with the postgres user
   • CSV HEADER - This is the feature that let's you export the table headings as well, please note that the HEADER argument has only been introduced in Postgres 8.1

• Add New Search
• Comments

Write comment

Your Contact Details:

Name:

Email: do not notifynotify

Comment:

Title:

UBBCode:         -color-aquablackbluefuchsiagraygreenlimemaroonnavyolivepurpleredsilvertealwhiteyellow -size-tinysmallmediumlargehuge

Message:

Security

Please input the anti-spam code that you can read in the image.