Display a Query Title in VSQL

Jim_KnicelyJim_Knicely - Select Field - Administrator

The \C vsql meta-function allows you to set a title string that precedes query result output!

Example:

dbadmin=> SELECT * FROM dual;
dummy
-------
X
(1 row)

dbadmin=> \C 'The "Tried and True" DUAL table exists in Vertica!'
Title is "The "Tried and True" DUAL table exists in Vertica!".

dbadmin=> SELECT * FROM dual;
The "Tried and True" DUAL table exists in Vertica!
dummy
-------
X
(1 row)

Helpful Link:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/ConnectingToVertica/vsql/Meta-Commands/MetaCommandReference.htm

Have fun!

Sign In or Register to comment.