Re: Sv: Re: How to get shorter SERVER_VERSION in psql-prompt?

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Andreas Joseph Krogh <andreas(at)visena(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Sv: Re: How to get shorter SERVER_VERSION in psql-prompt?
Date: 2018-09-03 21:42:01
Message-ID: 20180903214201.q4heutmvdr6hlble@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2018-Sep-03, Andreas Joseph Krogh wrote:

> select setting as server_version from pg_settings where name =
> 'server_version';
> ┌──────────────────────────────────┐
> │          server_version          │
> ├──────────────────────────────────┤
> │ 10.5 (Ubuntu 10.5-1.pgdg18.04+1) │
> └──────────────────────────────────┘

Ugh. (So this is coming from "configure --with-extra-version" stuff)

I guess you could just split it out at the first whitespace ...

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2018-09-03 21:43:46 Re: Sv: Re: How to get shorter SERVER_VERSION in psql-prompt?
Previous Message Andreas Joseph Krogh 2018-09-03 21:41:17 Sv: Re: How to get shorter SERVER_VERSION in psql-prompt?