Can someone help me figure out how to not include header info. in an out file when running a select statement via the vsql command line?
For instance, in the following example I don't want the column header information to be included in the out file. I just want the two records returned from the select...
Code: Select all
vert1$ vsql -U dbadmin -c "select * from no_out" -o /usr/home/dbadmin/test.txt
vert1$ cat /usr/home/dbadmin/test.txt
num | text
-----+-------------------------------------------------------------------
1 | I just want this data
2 | I just want this data too, not the column header in the out file!
(2 rows)