[GENERAL] Adding the host name to the PgSQL shell

2009-06-08 Thread Madison Kelly
Hi all, I work on a development and production server, and I am always double-checking myself to make sure I am doing something on the right server. Is there a way, like in terminal shells, to change the PgSQL shell's prompt from 'db=' to something like 'h...@db='? I'm on PgSQL 8.1

Re: [GENERAL] Adding the host name to the PgSQL shell

2009-06-08 Thread Scott Mead
On Mon, Jun 8, 2009 at 12:44 PM, Madison Kelly li...@alteeve.com wrote: Hi all, I work on a development and production server, and I am always double-checking myself to make sure I am doing something on the right server. Is there a way, like in terminal shells, to change the PgSQL

Re: [GENERAL] Adding the host name to the PgSQL shell

2009-06-08 Thread Madison Kelly
Scott Mead wrote: On Mon, Jun 8, 2009 at 12:44 PM, Madison Kelly li...@alteeve.com mailto:li...@alteeve.com wrote: Hi all, I work on a development and production server, and I am always double-checking myself to make sure I am doing something on the right server. Is

Re: [GENERAL] Adding the host name to the PgSQL shell

2009-06-08 Thread Scott Mead
On Mon, Jun 8, 2009 at 1:30 PM, Madison Kelly li...@alteeve.com wrote: That works like a charm, thank you! No problem :) Next question though; How can I get it to save my custom prompt across sessions/server restarts? It there something equivalent to '.bash_profile'? ~/.psqlrc

Re: [GENERAL] Adding the host name to the PgSQL shell

2009-06-08 Thread Madison Kelly
Scott Mead wrote: On Mon, Jun 8, 2009 at 1:30 PM, Madison Kelly li...@alteeve.com mailto:li...@alteeve.com wrote: That works like a charm, thank you! No problem :) Next question though; How can I get it to save my custom prompt across sessions/server restarts? It

Re: [GENERAL] Adding the host name to the PgSQL shell

2009-06-08 Thread Roderick A. Anderson
Scott Mead wrote: On Mon, Jun 8, 2009 at 12:44 PM, Madison Kelly li...@alteeve.com mailto:li...@alteeve.com wrote: Hi all, I work on a development and production server, and I am always double-checking myself to make sure I am doing something on the right server. Is