Saving psql output to csv file

Question

I have a query written in a file located at /path/to/query. How can I save the output result to a csv file, without using COPY in the query? I tried the following command, but the output file's fields are separated by " | ".

psql -U username -d dbname -f /path/to/query -o /path/to/output/file -F ','

Tom-db · Accepted Answer · 2015-05-26 18:22:42Z

12

It is not explained in the documentation, but the -F option requires the -A option (unaligned table output) to work:

psql -U username -d dbname -f /path/to/query -o /path/to/output/file -F ',' -A

If you don't wish the headers in your csv, this means, without extra rows at the top and at the bottom, use the -t option too.

psql -U username -d dbname -f /path/to/query -o /path/to/output/file -F ',' -A -t

From the help:

-A, --no-align unaligned table output mode
-F, --field-separator=STRING set field separator (default: "|")
-t, --tuples-only print rows only

edited May 26, 2015 at 18:22

answered May 26, 2015 at 5:20

Tom-db

6,9584 gold badges33 silver badges51 bronze badges

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

4 Comments

Agrim Pathak Over a year ago

It works. This is a little nit-picky, but how do I get rid of 2 extra lines: "SELECT <random number>" at the top and "(rows <number of rows>)" at the bottom?

Tom-db Over a year ago

If you want only tuples, without other rows at bottom and at the top, use the option -t: psql -U username -d dbname -f /path/to/query -o /path/to/output/file -F ',' -A -t.

Agrim Pathak Over a year ago

I tried that. I still saw "SELECT<random number">, though the row count at the bottom disappeared.

Tom-db Over a year ago

This comes from the query. Post in your question the content of the file with the sql code.

Collectives™ on Stack Overflow

Saving psql output to csv file

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related