操作系統(tǒng)：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
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.
