Re: select version() with internal number version?
| От | Wèi Cōngruì |
|---|---|
| Тема | Re: select version() with internal number version? |
| Дата | |
| Msg-id | CAPxZtjHBtqVrcumktoxgS9acqshsM8NxVNPc7Tjm2E+oFCH4pw@mail.gmail.com обсуждение исходный текст |
| Ответ на | select version() with internal number version? (Luca Ferrari <fluca1978@gmail.com>) |
| Ответы |
Re: select version() with internal number version?
|
| Список | 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 по дате отправления: