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: > > > >[EMAIL PROTECTED]:database $ > > > >as the prompt. Anyone got any ideas/references? > > > > > > > > Put > \set PROMPT1 '[EMAIL PROTECTED]:%~%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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
