On Thu, Jul 20, 2017 at 7:23 PM, Igor Korot <ikoro...@gmail.com> wrote:
> On Thu, Jul 20, 2017 at 10:19 PM, Andreas Kretschmer > <andr...@a-kretschmer.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.