Re: Custom prompt

On 9/24/12 12:20 PM, craig@gtek.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
listarchives? Everything I tried found every page with either the word custom, the word prompt, or both words somewhere
inthe 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