Re: psql prompt

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?
>
> Aleksey
>
>
> 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
>>
>> Best,
>> -at
>>
>
> --
> Sent via lapug mailing list (lapug(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/lapug

~~~~~

may all your sequences converge...