Find the Version of Vertica that Created a Database: Quick Tip

Posted November 19, 2018 by James Knicely, Vertica Field Chief Technologist

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:

Have fun!