| From: | Scott Mead <scott(dot)lists(at)enterprisedb(dot)com> |
|---|---|
| To: | Madison Kelly <linux(at)alteeve(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Adding the host name to the PgSQL shell |
| Date: | 2009-06-08 17:21:22 |
| Message-ID: | d3ab2ec80906081021p6d8aadbbh35676b8f1295135d@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Jun 8, 2009 at 12:44 PM, Madison Kelly <linux(at)alteeve(dot)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(at)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:
http://www.postgresql.org/docs/8.1/static/app-psql.html#APP-PSQL-PROMPTING
--Scott
>
>
> Thanks all!
>
> Madi
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Madison Kelly | 2009-06-08 17:30:50 | Re: Adding the host name to the PgSQL shell |
| Previous Message | Richard Huxton | 2009-06-08 17:16:41 | Re: [SQL] 'cost' and 'rows' for volitile function |