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

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: 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:43:46
Message-ID: deb8d10b-327e-069e-01de-4b6f0e9af07c@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 09/03/2018 03:42 PM, Alvaro Herrera wrote:
> 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 ...
>
Does that also diddle the value of "server_version_num"?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christoph Moench-Tegeder 2018-09-03 21:46:52 Re: Sv: Re: How to get shorter SERVER_VERSION in psql-prompt?
Previous Message Alvaro Herrera 2018-09-03 21:42:01 Re: Sv: Re: How to get shorter SERVER_VERSION in psql-prompt?