Server name in psql prompt

From: Mark Morgan Lloyd <markMLl(dot)pgsql-general(at)telemetry(dot)co(dot)uk>
To: pgsql-general(at)PostgreSQL(dot)org
Subject: Server name in psql prompt
Date: 2010-01-08 11:20:36
Message-ID: hi74e4$f6o$1@pye-srv-01.telemetry.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

I've just come close to dropping a table that would have been
embarrassing because I couldn't see which server an instance of psql was
talking to. Now obviously that's due to lackwittedness on my part and it
could be cured by installing psqlrc files- but this might not be a
viable option since it means chasing down every psql binary that's been
installed on the LAN in an attempt to protect users from self-harm: far
nicer if the default psql prompt could be loaded from the server.

--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Filip Rembiałkowski 2010-01-08 11:28:09 Re: Server name in psql prompt
Previous Message Alban Hertroys 2010-01-08 11:11:57 Re: Rows missing from table despite FK constraint