| 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: | Whole Thread | Raw Message | 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]
| 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 |