PostgreSQL VERSION() Function
The PostgreSQL VERSION() function returns the PostgreSQL version information.
Syntax
VERSION()
Parameters
No parameter is required.
Return Value
Returns the PostgreSQL version information.
Example:
The example below shows the usage of VERSION() function.
SELECT VERSION();
The above query will return the PostgreSQL version information and the output of the above query will be similar to (word wrapped for readability):
SELECT VERSION();
Result: 'PostgreSQL 14.1 (Debian 14.1-1.pgdg110+1) on x86_64-pc-linux-gnu,
compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit'
❮ PostgreSQL Functions
