Re: Backward compatibility

On Thu, Jul 20, 2017 at 7:23 PM, Igor Korot <ikorot01(at)gmail(dot)com> wrote:

> On Thu, Jul 20, 2017 at 10:19 PM, Andreas Kretschmer
> <andreas(at)a-kretschmer(dot)de> wrote:
> >
> >>Is there a query or a libpg function which can return the version of
> >>the server I'm running?
>

> > Select version();
>
> Here is the results:
>
> draft=# SELECT version();
>
>
> version
> ------------------------------------------------------------
> ------------------------------------------------------------
> -----------------------------------------
> PostgreSQL 9.1.24 on x86_64-apple-darwin, compiled by
> i686-apple-darwin10-llvm-gcc-4.2 (GCC) 4.2.1 (Based on Apple Inc.
> build 5658) (LLVM build 2335.6), 64-bit
> (1 row)
>
> Is there a way to get just "9.1.24" without everything else?
>

​SHOW server_version_num;

90124​ should be the result (don't have that version installed to
copy-paste)

90506 is the version I have at my fingertips.

David J.