sql formatting in vertica

[iw84n01]

HI,

Just wondering is there anyway I can remove the number of row returned ?

something like set feedback off in oracle ;

select count(*) from sessions;
count
------------
7

(7 rows) => (possible to remove ?)

[iw84n01]

got the answer =)

\pset footer

[debfawn]

Thanks for sharing this. Does anyone know how to do the same when executing a query from the command line?

[JimKnicely]

Use the -P switch:

Code: Select all

[dbadmin@v1 ~]$ vsql -P footer=off -c "select count(*) from sessions;"
 count
-------
     1

Refer to the topic "SET NOCOUNT equivalent in Vertica" here: http://www.vertica-forums.com/viewtopic.php?f=6&t=619

[iw84n01]

Use the -P switch:

Code: Select all

[dbadmin@v1 ~]$ vsql -P footer=off -c "select count(*) from sessions;"
 count
-------
     1

Refer to the topic "SET NOCOUNT equivalent in Vertica" here: http://www.vertica-forums.com/viewtopic.php?f=6&t=619

@knicely87 thanks also for sharing =)