Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Find the Version of Vertica that Created a Database

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

Example:

dbadmin=> SELECT version();
              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;
database_create_version
-------------------------
v9.1.0-3
(1 row)

Helpful Link:
https://www.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/AdministratorsGuide/Diagnostics/DeterminingYourVersionOfVertica.htm

Have fun!

Sign In or Register to comment.

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.