查看 PostgreSQL 数据库的版本号,可用方法很多,本文列举一下可选的方法。
1. version()
enmotech=# select version();
version
------------------------------------------------------------------------------------------------------------------
PostgreSQL 11.2 on x86_64-apple-darwin17.7.0, compiled by Apple LLVM version 10.0.0 (clang-1000.11.45.5), 64-bit
(1 row)
2. show server_version
enmotech=# show server_version;
server_version
----------------
11.2
(1 row)
3. server_version_num
enmotech=# select current_setting('server_version_num');
current_setting
-----------------
110002
(1 row)
enmotech=# show server_version_num;
server_version_num
--------------------
110002
(1 row)