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)
