Contents
server_version_num
A read-only server parameter containing the server version number
server_version_num is a read-only configuration parameter reporting the PostgreSQL server version number as an integer.
server_version_num was added in PostgreSQL 8.2.
Usage
server_version_num reports the current server version number as an integer, which represents a canonical version number without needing to parse a textual representation (e.g. 120007 vs 12.7), and can reliably be used to compare versions.
server_version_num reports the value of PG_VERSION_NUM defined when the server was built.
Change history
- PostgreSQL 8.2
- added (commit 04912899)
Examples
Basic usage example for server_version_num:
postgres=# SHOW server_version_num; server_version_num -------------------- 120007 (1 row)
Comparision of the various forms of server version information which are available:
postgres=# SELECT version(),
current_setting('server_version') AS server_version,
current_setting('server_version_num') AS server_version_num\gx
-[ RECORD 1 ]------+-------------------------------------------------------------------------------------------------------
version | PostgreSQL 12.7 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20191121 (Red Hat 8.3.1-5), 64-bit
server_version | 12.7
server_version_num | 120007
References
- PostgreSQL documentation: server_version_num