Re: Custom prompt

On 9/24/12 12:20 PM, craig(at)gtek(dot)biz wrote:
> Good afternoon,
>
> When accessing PostgreSQL via psql, is it possible to make use of a custom prompt? I would like something like postgres=# instead of just postgres=#. My search was fruitless (see next paragraph).
>
> And if I'm allowed two questions in one post, how does one search for a phrase such as "custom prompt" in the mailing list archives? Everything I tried found every page with either the word custom, the word prompt, or both words somewhere in the message. I just wanted to search for messages containing the exact phrase "custom prompt".
>
> Thanks,
> Craig
>
>
> Sent - Gtek Web Mail

Try along the lines of

psql -h some.host.com -U postgres -v "PROMPT1=*my_cool_prompt%/> " -d my_db

no se on the second Q.

ds