Re: WIP patch for TODO Item: Add prompt escape to display the client and server versions

Hi,

Le 17 juil. 09 à 23:24, Tom Lane a écrit :
> It seems unlikely that the DB version number would be worth the prompt
> space. In situations like that you'd much more likely need
> identifying
> info like the DB hostname and port number.

At work we have a fair number of database servers, some 8.2, lots of
8.3, and still some 8.1 I think. Triple the count for dev and preprod
environments. Of course as the DBA I tend not to forget easily which
server runs which version, and anyway when unsure I read the psql
banner.

But developers too will connect to those servers, and in the same
project they can handle both 8.2 and 8.3 databases. And they already
struggle to think about connecting with the right psql client version.
I'm often called for a "\d is broken, see?".

All of this to say "from the field" how much I think this could help
us to have a rich prompt with database name and major version. Oh and
they could refer to the right documentation, too, before asking me
about why it doesn't work as intended...

Regards,
--
dim