On Thu, Jul 20, 2017 at 10:19 PM, Andreas Kretschmer <andreas@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)