Re: Get version info

Hi, Adrian,

On Sun, Jul 5, 2026 at 9:53 AM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>
> On 7/5/26 1:18 AM, rob stone wrote:
> > On Sun, 2026-07-05 at 01:32 -0500, Igor Korot wrote:
> >> Hi, ALL,
> >> Google recommends using pg-config.
> >>
> >> However, some distro prefer to use pkg-config and don't even include
> >> local configuration file.
> >>
> >> Is this file located everywhere and if not - how do I check it inside
> >> configure.ac?
> >>
> >> Thank you.
> >>
> >
> >
> > See chapter 9.27.11, not Mr. Google.
> >
> > select version();
> >
> > PostgreSQL 18.4 (Debian 18.4-1+b1) on x86_64-pc-linux-gnu, compiled by
> > x86_64-linux-gnu-gcc (Debian 15.3.0-1) 15.3.0, 64-bit
> > (1 row)
>
> In addition:
>
> show server_version;
> server_version
> ------------------------------------
> 17.10 (Ubuntu 17.10-1.pgdg24.04+1)
>
>
> show server_version_num;
> server_version_num
> --------------------
> 170010

Again this is inside psql not inside shell/configure.ac

Thank you.

>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com