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.


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.

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