Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Turn Off Row Counts in VSQL

Jim_KnicelyJim_Knicely Administrator
edited January 2019 in Tips from the Team

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.


[[email protected] ~]$ vsql -c "SELECT * FROM dual;"
(1 row)

[[email protected] ~]$ vsql -P footer=off -c "SELECT * FROM dual;"

Helpful Links:

Have fun!

Sign In or Register to comment.

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.