execute a postgresql query from a file and write the output to another csv file

Question

I need to execute a query from a file and write the output of it to a CSV file. I want to keep the delimiter as ;. I have tried below queries.

psql -h localhost -p 5432 -U postgres -d postgres -f \path\to\sqlQuery.sql -o \path\to\result\result.csv

This query puts the result into a file but it is in a postgres result tabular format.

psql -h localhost -p 5432 -U postgres -d postgres -f copy(\path\to\sqlQuery.sql) to \path\to\result.csv csv header;

Above query is giving me a syntax error.

I'm looking for a way to use COPY command and \f or -f together so I'll be able to exceute the query from a file and also write the output to another CSV file with specified delimiter.

You might try psql -t -A -F"," -f in_file.sql -o out_file.csv. This doesn't give you value quoting though. — jbet
– jbet, Commented Aug 13, 2019 at 12:50

Laurenz Albe · Accepted Answer · 2019-08-13 14:38:53Z

1

Change your SQL script to use COPY:

COPY (/* your query */) TO STDOUT
   (FORMAT 'csv', DELIMITER ';');

answered Aug 13, 2019 at 14:38

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

execute a postgresql query from a file and write the output to another csv file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related