Turn Off Row Counts in VSQL: Quick Tip

Jim Knicely authored this tip.

The 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!