How to hide result set decoration in Psql output

You can use the -t or --tuples-only option:

psql --user=myuser -d mydb --output=result.txt -t -c "SELECT * FROM mytable;"

Edited (more than a year later) to add:

You also might want to check out the COPY command. I no longer have any PostgreSQL instances handy to test with, but I think you can write something along these lines:

psql --user=myuser -d mydb -c "COPY mytable TO 'result.txt' DELIMITER ','"

(except that result.txt will need to be an absolute path). The COPY command also supports a more-intelligent CSV format; see its documentation.

You can also redirect output from within psql and use the same option. Use \o to set the output file, and \t to output tuples only (or \pset to turn off just the rowcount "footer").

\o /home/flynn/queryout.txt\t onSELECT * FROM a_table;\t off\o

Alternatively,

\o /home/flynn/queryout.txt\pset footer off. . .

usually when you want to parse the psql generated output you would want to set the -A and -F ...

    # generate t.col1, t.col2, t.col3 ...    while read -r c; do test -z "$c" || echo  , $table_name.$c  | \       perl -ne 's/\n//gm;print' ; \       done < <(cat << EOF | PGPASSWORD=${postgres_db_useradmin_pw:-} \       psql -A -F  -v -q -t -X -w -U \       ${postgres_db_useradmin:-} --port $postgres_db_port --host $postgres_db_host -d \       $postgres_db_name -v table_name=${table_name:-}    SELECT column_name    FROM information_schema.columns    WHERE 1=1    AND table_schema = 'public'    AND table_name   =:'table_name'  ;    EOF    )    echo -e "\n\n"

You could find example of the full bash call here: