How to export table as CSV with headings on Postgresql?

by 
COPY products_273 TO '/tmp/products_199.csv' WITH (FORMAT CSV, HEADER);

as described in the manual.

More Related Contents:

  1. How to import CSV file data into a PostgreSQL table
  2. Save PL/pgSQL output from PostgreSQL to a CSV file
  3. Can I automatically create a table in PostgreSQL from a csv file with headers?
  4. In PostgreSQL, how to insert data with COPY command?
  5. ERROR: could not stat file “XX.csv”: Unknown error
  6. Importing .csv with timestamp column (dd.mm.yyyy hh.mm.ss) using psql \copy
  7. PostgreSQL: export resulting data from SQL query to Excel/CSV
  8. PostgreSQL: Show tables in PostgreSQL
  9. PostgreSQL “DESCRIBE TABLE”
  10. PostgreSQL function for last inserted ID
  11. What are ‘$$’ used for in PL/pgSQL
  12. How to update selected rows with values from a CSV file in Postgres?
  13. Adding ‘serial’ to existing column in Postgres
  14. Do nullable columns occupy additional space in PostgreSQL?
  15. How do I efficiently select the previous non-null value?
  16. Postgresql : Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections [duplicate]
  17. Dynamic SQL (EXECUTE) as condition for IF statement
  18. Disable PostgreSQL foreign key checks for migrations
  19. Prevent recursive trigger in PostgreSQL
  20. serial in postgres is being increased even though I added on conflict do nothing
  21. Can’t connect to Postgresql on port 5432
  22. PostgreSQL Error: Relation already exists
  23. Export specific rows from a PostgreSQL table as INSERT SQL script
  24. How to make a select with array contains value clause in psql
  25. Using row_to_json() with nested joins
  26. Process CSV Into Array With Column Headings For Key
  27. Sorting array elements
  28. How do I alter the date format in Postgres?
  29. OpenShift: How to connect to postgresql from my PC
  30. clojure.java.jdbc lazy query

Leave a Comment