vsql is a character-based, interactive, front-end utility that lets you type SQL statements and see the results. The results from vsql are formatted nicely with a border between columns. You are probably used to viewing border style 1, the default, but you may prefer border styles 0 or 2!
Example:
dbadmin=> \pset border
Border style is 1.
dbadmin=> SELECT * FROM test_table;
name | age | hair_color
---------+-----+-------------
Captain | 2 | Brown
Jane | 39 | Black
Josh | 17 | N/A
Lucy | 5 | White/Brown
(4 rows)
dbadmin=> \pset border 0
Border style is 0.
dbadmin=> SELECT * FROM test_table;
name age hair_color
------- --- -----------
Captain 2 Brown
Jane 39 Black
Josh 17 N/A
Lucy 5 White/Brown
(4 rows)
dbadmin=> \pset border 2
Border style is 2.
dbadmin=> SELECT * FROM test_table;
+---------+-----+-------------+
| name | age | hair_color |
+---------+-----+-------------+
| Captain | 2 | Brown |
| Jane | 39 | Black |
| Josh | 17 | N/A |
| Lucy | 5 | White/Brown |
+---------+-----+-------------+
(4 rows)
Helpful link:https://www.vertica.com/docs/latest/HTML/index.htm#Authoring/ConnectingToVertica/vsql/Meta-Commands/psetNAMEVALUE.htm
Have fun!
About the Author
Phil Molea
Sr. Information Developer, Vertica
Phil developed technical documentation in the areas of security and diagnostics for the Vertica Analytics Platform that enabled companies to extract value from their data at the speed and scale they need to thrive in today’s economy.
(Sadly, Phil passed away recently. He will be missed.)
