On Mon, Jun 8, 2009 at 12:44 PM, Madison Kelly <linux@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 shell's prompt from 'db=>' to something like 'host@db=>'? I'm on PgSQL 8.1 (server on Debian) and 8.3 (devel on Ubuntu), in case it matters.
You certainly can do this, very similar to PS1 on linux with bash: