Re: Get PG primary version without substring manipulation?

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: J T <jorge(dot)torralba(at)gmail(dot)com>, Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Get PG primary version without substring manipulation?
Date: 2024-06-14 07:25:12
Message-ID: efce406f2d4d3e394ca99fc0cccd8e3bf7a701f7.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


On Thu, Jun 13, 2024 at 5:52 AM Ron Johnson <ronljohnsonjr(at)gmail(dot)com> wrote:
> cut, awk, head, bash, etc are easy enough, but am I overlooking some intrinsic
> method of getting just PG's primary version number (9.6 or 14, in my case) without
> doing substring manipulation?

I like

psql -Atq -c "SELECT current_setting('server_version_num')::integer / 10000"

Yours,
Laurenz Albe

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Rui DeSousa 2024-06-14 15:22:06 Keepalive
Previous Message Ian Lawrence Barwick 2024-06-14 00:30:59 Re: Get PG primary version without substring manipulation?