How to exclude the total row information from VSQL output
<p>I am using VSQL to extract data from a table in CSV format using this command:</p>

<blockquote>
  <p>vsql -h [host_address] -d [db_name] -u [user_name] -w [password] -A -F , -t -f script_to_extract_data.sql -o output.csv</p>
</blockquote>

<p>However, it outputs column headers, data rows AND an extra row that indicates the total number of rows in the table like this:</p>

<pre><code>Geography,Product,Campaign,VariableName,Outlet,Creative,Period,VariableValue
Geo_00000,Product,BABY,web_sales,Total,Total,2016-10-03,24.06
Geo_00000,Product,BABY,web_sales,Total,Total,2016-10-08,67.17
Geo_00000,Product,BABY,web_sales,Total,Total,2016-10-17,404.67
(3 rows)
</code></pre>

<p>If I exclude the <code>-t</code> option, it'll output just the data like this:</p>

<pre><code>Geo_00000,Product,BABY,web_sales,Total,Total,2016-10-03,24.06
Geo_00000,Product,BABY,web_sales,Total,Total,2016-10-08,67.17
Geo_00000,Product,BABY,web_sales,Total,Total,2016-10-17,404.67
</code></pre>

<p>I would like the column headers AND the data, but not the total row number like this:</p>

<pre><code>Geography,Product,Campaign,VariableName,Outlet,Creative,Period,VariableValue
Geo_00000,Product,BABY,web_sales,Total,Total,2016-10-03,24.06
Geo_00000,Product,BABY,web_sales,Total,Total,2016-10-08,67.17
Geo_00000,Product,BABY,web_sales,Total,Total,2016-10-17,404.67
</code></pre>

<p>From reading through <a href="https://my.vertica.com/docs/7.1.x/HTML/Content/Authoring/ConnectingToHPVertica/vsql/CommandLineOptions.htm" rel="nofollow noreferrer">VSQL commandline options</a>, I don't think I have a way to restrict the total number of rows not show?? Anyone who is experienced with using VSQL via commandline could help me out, I would greatly appreciate the help. Thank you!</p>