Postgres Pro
Downloads
Home   >   mailing lists

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

From Ron Johnson
Subject Get PG primary version without substring manipulation?
Date
Msg-id CANzqJaCSdXU3a4PZzG5cmR9t0qvpL2Wf+EAYL2b1kUO_GXMjtw@mail.gmail.com
Whole thread Raw
Responses Re: Get PG primary version without substring manipulation?
Re: Get PG primary version without substring manipulation?
Re: Get PG primary version without substring manipulation?
List pgsql-admin
Tree view
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?

$ ssh foo.example.com pg_config --version
PostgreSQL 9.6.24
$ ssh foo.example.com psql --version
psql (PostgreSQL) 9.6.24
$ psql -h foo.example.com -Xtc "SELECT version();"
 PostgreSQL 9.6.24 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit

$ ssh bar.example.com pg_config --version
PostgreSQL 14.12
$ ssh bar.example.com psql --version
psql (PostgreSQL) 14.12
$ psql -h bar.example.com -Xtc "SELECT version();"
 PostgreSQL 14.12 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-20), 64-bit

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: How to Handle Sequences in Logical Bi-Directional Replication
Next
From: Peter Adlersburg
Date:
Subject: Re: Get PG primary version without substring manipulation?