Full table backup to csv with header

suggest change

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

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

Found a mistake? Have a question or improvement idea? Let me know.

Export to csv:

* Export PostgreSQL database table header and data to CSV file

* Export PostgreSQL table to csv with header for some columns

* Full table backup to csv with header

* copy from query

Table Of Contents

0 Getting Started

1 JSON Support

2 Role Management

3 Common Table Expressions WITH

4 Accessing Data Programatically

5 Backup and Restore

6 Table Creation

7 INSERT

8 UPDATE

9 Dates, Timestamps and Intervals

10 Aggregate Functions

11 Programming with PLPGSQL

12 Inheritance

13 High Availability

14 Triggers and Trigger Functions

15 EXTENSION dblink and postgres fdw

16 Window Functions

17 Postgres Tips and Tricks

18 Backup script for a production DB

19 Comments

20 Export to csv

21 Data Types

22 Recursive queries

23 Postgres cryptographic functions

24 Event Triggers

25 SELECT

26 Connect from Java

27 Find String Length

28 COALESCE

29 Contributors