Home How to hide result set decoration in Psql output
 How do you hide the column names and row count in the output from psql? I'm running a SQL query via psql with: psql --user=myuser -d mydb --output=result.txt -c "SELECT * FROM mytable;"  and I'm expecting output like: 1,abc 2,def 3,xyz  but instead I get: id,text ------- 1,abc 2,def 3,xyz (3 rows)  Of course, it's not impossible to filter the top two rows and bottom row out after the fact, but it there a way to do it with only psql? Reading over its manpage, I see options for controlling the field delimiter, but nothing for hiding extraneous output.