Re: Server name in psql prompt - Mailing list 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