Cool! Now I can really screw with my users! Thanks for the tip.
On Mar 26, 2010, at 1:44 PM, Aleksey Tsalolikhin wrote:
> Correction: this gives you the client hostname, not the server hostname.
> I don't see any way to get the server hostname from the server itself.
> Maybe some kind of SQL query can tell me that?
> On Fri, Mar 26, 2010 at 1:40 PM, Aleksey Tsalolikhin
> <atsaloli(dot)tech(at)gmail(dot)com> wrote:
>> Hi, list. Just found out you can customize the psql prompt.
>> For example:
>> \set PROMPT1 '%n(at)%/ on %`hostname` (%M:%>) %# '
>> Tells you db user, db name, server hostname,
>> and the IP address and port that the db server
>> listens on, plus the prompt (regular or superuser).
>> If you like it, put it in your ~/.psqlrc
>> You can go fancy with colors, etc.
>> Reference: http://www.postgresql.org/docs/8.4/interactive/app-psql.html
> Sent via lapug mailing list (lapug(at)postgresql(dot)org)
> To make changes to your subscription:
may all your sequences converge...
In response to
lapug by date
|Next:||From: Aleksey Tsalolikhin||Date: 2010-03-26 21:15:30|
|Subject: How to print server IP address (Was Re: psql prompt)|
|Previous:||From: Aleksey Tsalolikhin||Date: 2010-03-26 20:44:38|
|Subject: Re: psql prompt|