VERSION

VERSION is a command in SQL that is used to retrieve the current version of the SQL Server that is being used. The SQL server returns string information indicating the name of the software and the version number. This command might vary slightly in syntax depending on the SQL database management system being used.

VERSION()

Example

SELECT VERSION();

Output

"PostgreSQL 13.2, compiled by Visual C++ build 1914, 64-bit"

Explanation

The VERSION() function in PostgreSQL is executed to get the details of the version of the currently running PostgreSQL database. The output string includes the PostgreSQL version along with some additional information such as build type and platform details.

For in-depth explanations and examples SQL keywords where you write your SQL, install our extension.