Re: Prompts in psql

On Mon, 1 Sep 2003, Renney Thomas wrote:

> 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.

I've just looked in the manpage - does anyone know where psql looks for
a system-wide psqlrc?

--

Sam Barnett-Cormack
Software Developer                           |  Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk)  |  Lancaster University