Find the Version of Vertica that Created a Database

Jim_KnicelyJim_Knicely - Select Field - Administrator

You can run the VERSION() function as one method of displaying the current version of Vertica.


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

But what if you want to know the version of Vertica running when you created the current database? For that info you can query the VS_GLOBAL_SETTINGS table.

dbadmin=> SELECT dbcreateversion "database_create_version"
dbadmin->   FROM vs_global_settings;
(1 row)

Helpful Link:

Have fun!

Sign In or Register to comment.