Make a Cow Display Query Results in VSQL
Jim_Knicely
- Select Field - Administrator
I used to have fun with the amusing old Linux command Cowsay. It inserts any input into a word bubble and draws an ASCII cow to talk to you.
You can make the cow display your query results in VSQL!
Example:
dbadmin=> \! rpm -qa | grep cowsay
cowsay-3.04-4.el7.noarch
dbadmin=> \! cowsay I love VERTICA!
_________________
< I love VERTICA! >
-----------------
\ ^__^
\ (oo)\_______
(__)\ )\/\
||----w |
|| ||
dbadmin=> CREATE TABLE some_data (c VARCHAR(10));
CREATE TABLE
dbadmin=> INSERT INTO some_data SELECT 'A';
OUTPUT
--------
1
(1 row)
dbadmin=> INSERT INTO some_data SELECT 'B';
OUTPUT
--------
1
(1 row)
dbadmin=> INSERT INTO some_data SELECT 'C';
OUTPUT
--------
1
(1 row)
dbadmin=> INSERT INTO some_data SELECT 'D';
OUTPUT
--------
1
(1 row)
dbadmin=> COMMIT;
COMMIT
dbadmin=> \! vsql -Atc "SELECT c FROM some_data ORDER BY c;" | cowsay
_________
< A B C D >
---------
\ ^__^
\ (oo)\_______
(__)\ )\/\
||----w |
|| ||
Helpful Links:
https://en.wikipedia.org/wiki/Cowsay
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/ConnectingToVertica/vsql/Meta-Commands/MetaCommandReference.htm
Have fun!
1