SHOW server_version;
SHOW server_version_num;
I can fetch the version by these two statement.
On Thu, Aug 9, 2018 at 3:01 PM Luca Ferrari <fluca1978@xxxxxxxxx> wrote:
HI all,
I see a lot of external tools that do a 'SELECT version()' and then
parse the output to get the version number (e.g., 10.4).
My opinion is that this is not a good approach, since the output of
version includes a lot of information and can mismatch a poorly
written regular _expression_. It would be better to use pg_config
--version, byt again there is the needing for mangling the data.
Is there any way to get directly the PostgreSQL version number?
Thanks,
Luca
