SET NOCOUNT equivalent in Vertica

[fsalvelt]

Hey,

Is there a feature available in Vertica when writing scripts that is similar to the SET NOCOUNT command in SQL Server which will stop the message indicating the number of rows affected by a Transact-SQL statement from being returned as part of the results.

Thank you!

[id10t]

Hi!

Do you want standard output without last row where rows counted, but with a fist row with columns names?

[fsalvelt]

Hey,

I would just like the output to not have the row count.

So for a simple statement like "select count(*) from dual;" I would like to get back just:

count
-------
1

... not this:

count
-------
1
(1 row)

Thanks for the quick response, btw!

[id10t]

Hi!

vsql has no such ability/option (it vsql issue, not Vertica). If you don't need header so try option "tuples only" (`\t` - inside of script or `-t` as command line arg).
Do you will accept workarounds?

[fsalvelt]

Hi sKwa,

Sure, I'm willing to use a work around

I wonder if Vertica plans on adding an option to vsql in the future for this?

Thanks!!!

[id10t]

Hi!

Sorry I was wrong. No work around - direct solution: variable FOOTER

• From shell:

  Code: Select all

  [ ~ ]$ vsql -P footer=off -c "select * from nums limit 5"
   id 
  ----
    1
    2
    3
    4
    5
  

• From vsql or script:

  Code: Select all

  dbadmin=> \pset footer off
  Default footer is off.
  dbadmin=> select * from nums limit 5; 
   id 
  ----
    1
    2
    3
    4
    5
  
  dbadmin=> 
  

[fsalvelt]

That's perfect!!! You're brilliant, sKwa! Thanks, man!