Re: Server name in psql prompt

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Mark Morgan Lloyd <markMLl(dot)pgsql-general(at)telemetry(dot)co(dot)uk>
Cc: pgsql-general(at)PostgreSQL(dot)org
Subject: Re: Server name in psql prompt
Date: 2010-01-08 13:57:32
Message-ID: 1262959052.19367.107431.camel@ebony
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 2010-01-08 at 11:20 +0000, Mark Morgan Lloyd wrote:

> Is there any way of getting psql to display the name of the
> currently-connected server in its prompt, and perhaps a custom string
> identifying e.g. a disc set, without having to create a psqlrc file on
> every client system that's got a precompiled psql installed?

It's a reasonable request but PostgreSQL databases don't have specific
names. You have to set up the logic yourself.

--
Simon Riggs www.2ndQuadrant.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Konrad Garus 2010-01-08 13:58:01 Re: Rows missing from table despite FK constraint
Previous Message Tom Lane 2010-01-08 13:55:01 Re: Rows missing from table despite FK constraint