Re: psql prompt

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
>