Re: Backward compatibility

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Backward compatibility
Date: 2017-07-21 03:15:13
Message-ID: 989d629b-0b34-6e76-430a-1d3d72a2a203@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/20/2017 7:57 PM, David G. Johnston wrote:
>
> Actually, The docs do cover how to do this directly in libpq.
>
odds are pretty good that...

|PQserverVersion|

Returns an integer representing the backend version.

int PQserverVersion(const PGconn *conn);

Applications might use this function to determine the version of the
database server they are connected to. The number is formed by
converting the major, minor, and revision numbers into
two-decimal-digit numbers and appending them together. For example,
version 8.1.5 will be returned as 80105, and version 8.2 will be
returned as 80200 (leading zeroes are not shown). Zero is returned
if the connection is bad.

Actually invokes `show server_version_num;'

--
john r pierce, recycling bits in santa cruz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2017-07-21 03:40:06 Re: Backward compatibility
Previous Message John R Pierce 2017-07-21 03:12:34 Re: Backward compatibility