Re: Get PG primary version without substring manipulation?

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