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


What Version of Vertica am I Running? — Vertica Forum

What Version of Vertica am I Running?

[Deleted User][Deleted User] Administrator
in Tips from the Team

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!

Comments

  • HibikiHibiki Vertica Employee Employee

    Correction:

    • X is the major release number
    • Y is the minor release number
    • Z is the service pack number
    • R is the hotfix number
Sign In or Register to comment.