Re: [GENERAL] Backward compatibility
| От | David G. Johnston |
|---|---|
| Тема | Re: [GENERAL] Backward compatibility |
| Дата | |
| Msg-id | CAKFQuwZdrKmbb3Nzs=QktaA8Umq0CueuhedS8aEpfTC=fgONZQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [GENERAL] Backward compatibility (Igor Korot <ikorot01@gmail.com>) |
| Список | pgsql-general |
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)
90506 is the version I have at my fingertips.
David J.
В списке pgsql-general по дате отправления: