Re: select version() with internal number version? - Mailing list pgsql-general

From Wèi Cōngruì
Subject Re: select version() with internal number version?
Date
Msg-id CAPxZtjHBtqVrcumktoxgS9acqshsM8NxVNPc7Tjm2E+oFCH4pw@mail.gmail.com
Whole thread Raw
In response to select version() with internal number version?  (Luca Ferrari <fluca1978@gmail.com>)
Responses Re: select version() with internal number version?
List pgsql-general
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@gmail.com> 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

pgsql-general by date:

Previous
From: Luca Ferrari
Date:
Subject: select version() with internal number version?
Next
From: hmidi slim
Date:
Subject: postgresql-10-pldebugger in alpine linux distribution