0 环境信息

• 操作系统：Linux version 3.10.0-957.el7.x86_64 (mockbuild@kbuilder.bsys.centos.org) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-36) (GCC) ) #1 SMP Thu Nov 8 23:39:32 UTC 2018
• PostgreSQL: Docker部署，PostgreSQL 14.2 (Debian 14.2-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit

1 命令行查看postgres --version

$ postgres --version
postgres (PostgreSQL) 14.2 (Debian 14.2-1.pgdg110+1)

2 SQL语句SELECT version()

postgres=# SELECT version();
                                                           version

-----------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 14.2 (Debian 14.2-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit

3 SQL语句SHOW SERVER_VERSION

postgres=# SHOW SERVER_VERSION;
         server_version
--------------------------------
 14.2 (Debian 14.2-1.pgdg110+1)
(1 row)

4 SQL语句SHOW server_version_num

postgres=# SHOW server_version_num;
 server_version_num
--------------------
 140002
(1 row)

5 psql连接PostgreSQL Server时只显示psql的版本信息

$ docker run -it --rm postgres  psql -h 172.17.0.3 -p 5432 -U postgres
Password for user postgres:
psql (14.2 (Debian 14.2-1.pgdg110+1))
Type "help" for help.

$ psql --version
psql (PostgreSQL) 14.2 (Debian 14.2-1.pgdg110+1)