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 <fluca1...@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 > >