Retrieve Vertica Version from SQL

[me_theonlyone]

I was wondering if it was possible to retrieve the Vertica version through some SQL statement. I know this might seem like a stupid question. but I was just wondering if there was a system table with information related to version.
I have posted this question to Stackoverflow: http://stackoverflow.com/q/17239537/2262959

is it possible or not?

[JimKnicely]

Try the version function.

Like this:

Code: Select all

Welcome to vsql, the Vertica Analytic Database interactive terminal.

Type:  \h or \? for help with vsql commands
       \g or terminate with semicolon to execute query
       \q to quit

dbadmin=> select version();
              version
------------------------------------
 Vertica Analytic Database v6.1.2-0
(1 row)

dbadmin=>