We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Display a Query Title in VSQL — Vertica Forum

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.