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