We are no longer accepting contributions to Documentation. Please see our post on meta.
Export PostgreSQL database table header and data to CSV file All Versions
8.4
9.0
9.1
9.2
9.3
9.4
9.5
9.6
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.
This draft deletes the entire topic.
Examples
-
-
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; -
-
COPY products TO 'D:\csv_backup\products_db.csv' DELIMITER ',' CSV HEADER; COPY categories TO 'D:\csv_backup\categories_db.csv' DELIMITER ',' CSV HEADER;
Please consider making a request to improve this example.
Still have a question about Export PostgreSQL database table header and data to CSV file?
Ask Question
Sign up or log in
Save edit as a guest
Join Stack Overflow
We recognize you from another Stack Exchange Network site!
Join and Save Draft