Turn Off Row Counts in VSQL: Quick Tip

Posted December 19, 2018 by Jim Knicely, Vertica Principal Solution Architect

he SET NOCOUNT command in SQL Server will stop the message indicating the number of rows affected by a Transact-SQL statement from being returned as part of the results.

You can accomplish the same thing in Vertica by shutting off the footer.

Example: [dbadmin@s18384357 ~]$ vsql -c "SELECT * FROM dual;" dummy ------- X (1 row) [dbadmin@s18384357 ~]$ vsql -P footer=off -c "SELECT * FROM dual;" dummy ------- X Helpful Links:

https://www.vertica.com/docs/latest/HTML/Content/Authoring/ConnectingToVertica/vsql/CommandLineOptions/PAssignment–psetAssignment.htm

https://www.vertica.com/docs/latest/HTML/Content/Authoring/ConnectingToVertica/vsql/Meta-Commands/psetNAMEVALUE.htm

Have fun!