What Version of Vertica am I Running?

SarahLSarahL Administrator, Moderator, Employee, Registered User, VerticaExpert, CABuser, VerticaPartners

Jim Knicely authored this tip.

The built-in VERSION function returns a VARCHAR that contains your Vertica node’s version information.

Example:

dbadmin=> SELECT version();
              version
------------------------------------
Vertica Analytic Database v9.1.0-2
(1 row)

The Vertica version is formatted as X.Y.Z-R, where…

  • X.Y is the two-digit Vertica major release number, e.g., 8.1, 9.0 and 9.1
  • Z is the service pack number, e.g., 7.2.3, 8.1.1 and 9.0.1
  • R is the hotfix number, e.g., 9.0.1-9 and 9.1.0-2

Have Fun!

Sign In or Register to comment.