How to exclude the total row information from VSQL output
Clash Royale CLAN TAG #URR8PPP How to exclude the total row information from VSQL output I am using VSQL to extract data from a table in CSV format using this command: vsql -h [host_address] -d [db_name] -u [user_name] -w [password] -A -F , -t -f script_to_extract_data.sql -o output.csv However, it outputs column headers, data rows AND an extra row that indicates the total number of rows in the table like this: 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) If I exclude the -t option, it'll output just the data like this: -t 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 I would like the column headers AND the data, but n...