Adding the host name to the PgSQL shell

From: Madison Kelly <linux(at)alteeve(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Adding the host name to the PgSQL shell
Date: 2009-06-08 16:44:51
Message-ID: 4A2D4003.2010109@alteeve.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)db=>'? I'm on PgSQL 8.1
(server on Debian) and 8.3 (devel on Ubuntu), in case it matters.

Thanks all!

Madi

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vyacheslav Kalinin 2009-06-08 17:04:22 Re: Duplicate key issue in a transaction block
Previous Message Bill Moran 2009-06-08 16:33:05 Re: Duplicate key issue in a transaction block