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!
Change the VSQL Result Set Border

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/9.1.x/HTML/index.htm#Authoring/ConnectingToVertica/vsql/Meta-Commands/psetNAMEVALUE.htm
Have fun!
0