Re: Prompts in psql - Mailing list pgsql-admin

From Renney Thomas
Subject Re: Prompts in psql
Date
Msg-id 3F539518.8060202@yahoo.com
Whole thread Raw
In response to Prompts in psql  (Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>)
Responses Re: Prompts in psql  (Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>)
List 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@host:database $
>
>as the prompt. Anyone got any ideas/references?
>
>
>

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


pgsql-admin by date:

Previous
From: weigelt@metux.de
Date:
Subject: Running postgresql on an memory stick
Next
From: Peter Eisentraut
Date:
Subject: Re: pg_atoi: error in.....: can't parse..."