The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Turn Off Row Counts in VSQL

Jim_KnicelyJim_Knicely Administrator
edited January 8 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.

Example:

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

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

Helpful Links:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/ConnectingToVertica/vsql/CommandLineOptions/PAssignment--psetAssignment.htm

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

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.