• Tom Lane's avatar
    Add psql variables showing server version and psql version. · 9ae9d8c1
    Tom Lane authored
    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
    9ae9d8c1
psql-ref.sgml 177 KB