Home > mailing lists

How to get shorter SERVER_VERSION in psql-prompt? - Mailing list pgsql-general

From	Andreas Joseph Krogh
Subject	How to get shorter SERVER_VERSION in psql-prompt?
Date	September 4, 2018 02:52:31
Msg-id	VisenaEmail.45.809b268f4ddd981.165a1337341@tc7-visena Whole thread Raw
Responses	Re: How to get shorter SERVER_VERSION in psql-prompt? Re: How to get shorter SERVER_VERSION in psql-prompt?
List	pgsql-general

Hi all, I'm using the Ubuntu-packages and have this in my .psqlrc:

\set PROMPT1 '%[%033[35m%]%n@%m:%>%[%033[0m%] %:server_version: %[%033[32m%]%/%[%033[0m%]%R%# '

This results in this verver_version:

10.5 (Ubuntu 10.5-1.pgdg18.04+1)

Is it possible to adjust this somehow so it outputs only "10.5"?

Thanks in advance.

--

Andreas Joseph Krogh

CTO / Partner - Visena AS

Mobile: +47 909 56 963

andreas@visena.com

Attachment

msg-1557446-3.png

pgsql-general by date:

Previous

From: Mate Varga
Date: 04 September 2018, 01:57:28
Subject: Re: very slow largeobject transfers through JDBC

Next

From: Alvaro Herrera
Date: 04 September 2018, 03:03:10
Subject: Re: How to get shorter SERVER_VERSION in psql-prompt?