Turn Off Row Counts in VSQL: Quick Tip

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:



Have fun!