| From: | Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk> |
|---|---|
| To: | pgsql-general(at)PostgreSQL(dot)org, Mark Morgan Lloyd <markMLl(dot)pgsql-general(at)telemetry(dot)co(dot)uk> |
| Subject: | Re: Server name in psql prompt |
| Date: | 2010-01-08 11:30:50 |
| Message-ID: | 584487.28650.qm@web23607.mail.ird.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
--- On Fri, 8/1/10, Mark Morgan Lloyd <markMLl.pgsql-
> 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?
You could use the psql -v option to set the PROMPT variables (or set them as ENV)
see:
http://www.postgresql.org/docs/8.3/static/app-psql.html
http://www.postgresql.org/docs/8.3/static/app-psql.html#APP-PSQL-PROMPTING
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Konrad Garus | 2010-01-08 11:43:48 | Re: Rows missing from table despite FK constraint |
| Previous Message | Filip Rembiałkowski | 2010-01-08 11:28:09 | Re: Server name in psql prompt |