pgsql: Add psql variables showing server version and psql version.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add psql variables showing server version and psql version.
Date: 2017-09-05 14:51:41
Message-ID: E1dpFCX-0004YD-E7@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

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.

Fabien Coelho, reviewed by Pavel Stehule

Discussion: https://postgr.es/m/alpine.DEB.2.20.1704020917220.4632@lancre

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/9ae9d8c1549c384dbdb8363e1d932b7311d25c56

Modified Files
--------------
doc/src/sgml/ref/psql-ref.sgml | 24 ++++++++++++++++++++++--
src/bin/psql/command.c | 19 +++++++++++++++++++
src/bin/psql/help.c | 9 ++++++++-
src/bin/psql/startup.c | 3 +++
4 files changed, 52 insertions(+), 3 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Simon Riggs 2017-09-05 15:29:15 Re: pgsql: Add psql variables showing server version and psql version.
Previous Message Tom Lane 2017-09-05 14:17:21 pgsql: Reformat psql's --help=variables output.

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2017-09-05 14:52:47 Re: Variable substitution in psql backtick expansion
Previous Message Daniel Gustafsson 2017-09-05 13:47:06 Re: Proposal for changes to recovery.conf API