Add psql variables showing server version and psql version.
authorTom Lane
Wed, 6 Sep 2017 15:35:31 +0000 (11:35 -0400)
committerTom Lane
Wed, 6 Sep 2017 15:35:31 +0000 (11:35 -0400)
commita6c678f018d3a30a88440d3c20cf8e7cd6592a32
tree69eaa8fd0feb74170df1a998fe2fae2112ac83f4
parent483882905a9a5dc72c9487ceee12320b9630ba2b
Add psql variables showing server version and psql version.

We already had a psql variable VERSION that shows the verbose form of
psql's own version.  Add VERSION_NAME to show the short form (e.g.,
"11devel") and VERSION_NUM to show the numeric form (e.g., 110000).
Also add SERVER_VERSION_NAME and SERVER_VERSION_NUM to show the short and
numeric forms of the server's version.  (We'd probably add SERVER_VERSION
with the verbose string if it were readily available; but adding another
network round trip to get it seems too expensive.)

The numeric forms, in particular, are expected to be useful for scripting
purposes, now that psql can do conditional tests.

Back-patch of commit 9ae9d8c1549c384dbdb8363e1d932b7311d25c56.

Fabien Coelho, reviewed by Pavel Stehule

Discussion: https://postgr.es/m/alpine.DEB.2.20.1704020917220.4632@lancre
doc/src/sgml/ref/psql-ref.sgml
src/bin/psql/command.c
src/bin/psql/help.c
src/bin/psql/startup.c