Postgres Pro
Downloads
Home   >   mailing lists

Adding the host name to the PgSQL shell - Mailing list pgsql-general

From Madison Kelly
Subject Adding the host name to the PgSQL shell
Date
Msg-id 4A2D4003.2010109@alteeve.com
Whole thread Raw
Responses Re: Adding the host name to the PgSQL shell
List pgsql-general
Tree view 
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.

Thanks all!

Madi

pgsql-general by date:

Previous
From: Vyacheslav Kalinin
Date:
Subject: Re: Duplicate key issue in a transaction block
Next
From: Richard Huxton
Date:
Subject: Re: [SQL] 'cost' and 'rows' for volitile function