Eliminate output from vsql in batch

[billykopecki]

Hey,

I have a bunch of vsql commands running scripts in batch mode and I would prefer that there be no out put from the vsql statements.

For instance, for this simple example:

Code: Select all

v1_server$ vsql -c "select count(*) from sessions"
 count
-------
     1
(1 row)

I don't want to see the results:

Code: Select all

 count
-------
     1

Is there a flag or switch I can use when running vsql to not show any output?

Thank you

[id10t]

I don't know how to do the output as you want, but look at option "\o" and send query output to file (/dev/null for example):

Code: Select all

dbadmin=> select * from test_table;
 id | name |      value       
----+------+------------------
  5 | foo  | 5.65665282582291
  6 | bar  | 5.42883523318981
  7 | baz  | 4.64158883361278
(3 rows)

Code: Select all

dbadmin=> \timing
Timing is on.
dbadmin=> \o /dev/null
dbadmin=> select * from test_table;
Time: First fetch (3 rows): 5.529 ms. All rows formatted: 5.585 ms

Code: Select all

dbadmin@suse:/tmp> vsql -c "select * from test_table"
 id | name |      value       
----+------+------------------
  5 | foo  | 5.65665282582291
  6 | bar  | 5.42883523318981
  7 | baz  | 4.64158883361278
(3 rows)

Code: Select all

dbadmin@suse:/tmp> echo -e  "\\\timing\n\o /dev/null\nselect * from test_table;" | vsql
Timing is on.
Time: First fetch (3 rows): 5.902 ms. All rows formatted: 5.985 ms

[jpcavanaugh]

vsql -o /dev/null -c "select count(*) from sessions"

[id10t]

@juniorfoo your solution always will be empty

PS

Code: Select all

dbadmin@suse:~/temp> vsql -c "select count(*) from sessions" | head -3
 count 
-------
     2

Code: Select all

dbadmin=> select count(*) from system_tables \g | head -3
 count 
-------
    72
dbadmin=> 

[Julie]

Cool! Thanks, guys. I was also looking at a way to do this.