How do I prevent PSQL from outputting the number of rows?

Question

Currently I can almost get a CSV from psql by simply running

psql -A -t -F'\t' -c "SELECT ...;" > myfile.csv

However it returns the number of rows at the end of the file. I can fix his with head -n -1

psql -A -t -F'\t' | head -n -1 | -c "SELECT ...;"

But with very large files seems like overkill. Is here a flag in psql where I can turn off number of records returned?

Oh, there are better answers [here](https://stackoverflow.com/questions/1517635/save-pl-pgsql-output-from-postgresql-to-a-csv-file) :) — Stanislav Kralin, Jun 18 '17 at 20:27
None of that works on redshift! Your answer is the better one. — ForeverConfused, Jun 18 '17 at 21:43

score 3 · Accepted Answer · answered Jun 19 '17 at 16:11

There is a number of common ways to get a CSV from PostrgeSQL (see e.g. this question). However not all of these ways are appropriate when working with Redshift, partly because Amazon Redshift is based on Postgres 8.0.2.

One can try to use --pset="footer=off" option to prevent psql from outputting the number of rows. Also, please consult 8.0.26 psql documentation.

How do I prevent PSQL from outputting the number of rows?

1 Answers1