Re: Prompts in psql

From: Renney Thomas <renneyt(at)yahoo(dot)com>
To:
Cc: PostgreSQL Administrators Mailing List <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Prompts in psql
Date: 2003-09-01 18:51:04
Message-ID: 3F539518.8060202@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Sam Barnett-Cormack wrote:

>Is there any way to change the prompt in the psql CLI client? In the
>same way as one does with bash, or other shells.
>
>Ideally I want:
>
>username(at)host:database $
>
>as the prompt. Anyone got any ideas/references?
>
>
>

Put
\set PROMPT1 '%n(at)%m:%~%R%# '
in your .psqlrc file.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2003-09-01 22:01:52 Re: pg_atoi: error in.....: can't parse..."
Previous Message weigelt 2003-09-01 18:16:14 Running postgresql on an memory stick