On 9/24/12 12:20 PM, craig@xxxxxxxx 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
