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