Postgres Pro
Downloads
Home   >   mailing lists

Re: Get PG primary version without substring manipulation? - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: Get PG primary version without substring manipulation?
Date
Msg-id efce406f2d4d3e394ca99fc0cccd8e3bf7a701f7.camel@cybertec.at
Whole thread Raw
In response to Re: Get PG primary version without substring manipulation?  (J T <jorge.torralba@gmail.com>)
List pgsql-admin
Tree view 
On Thu, Jun 13, 2024 at 5:52 AM Ron Johnson <ronljohnsonjr@gmail.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

pgsql-admin by date:

Previous
From: Ian Lawrence Barwick
Date:
Subject: Re: Get PG primary version without substring manipulation?
Next
From: Rui DeSousa
Date:
Subject: Keepalive