The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Make a Cow Display Query Results in VSQL

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