Re: [ADMIN] Prompts in psql

2003-10-21 Thread A.Bhuvaneswaran
> [EMAIL PROTECTED]:database $ > => \set PROMPT1 '[EMAIL PROTECTED]:%/ $' -- Refer psql manual for details regards, bhuvaneswaran ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomai

Re: [ADMIN] Prompts in psql

2003-09-02 Thread Peter Eisentraut
Sam Barnett-Cormack writes: > I've just looked in the manpage - does anyone know where psql looks for > a system-wide psqlrc? Nowhere. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: the planner will ignore your desire to

Re: [ADMIN] Prompts in psql

2003-09-02 Thread Sam Barnett-Cormack
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/

Re: [ADMIN] Prompts in psql

2003-09-01 Thread Renney Thomas
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 .

Re: [ADMIN] Prompts in psql

2003-09-01 Thread Bruce Momjian
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? Sure, see the psql manual page. -- Br