| From: | Sam Barnett-Cormack <s(dot)barnett-cormack(at)lancaster(dot)ac(dot)uk> |
|---|---|
| To: | Renney Thomas <renneyt(at)yahoo(dot)com> |
| Cc: | PostgreSQL Administrators Mailing List <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Prompts in psql |
| Date: | 2003-09-02 09:41:31 |
| Message-ID: | Pine.LNX.4.50.0309021040550.30231-100000@short.lancs.ac.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Mon, 1 Sep 2003, Renney Thomas wrote:
> Sam Barnett-Cormack wrote:
>
> >Is there any way to change the prompt in the psql CLI client? In the
> >same way as one does with bash, or other shells.
> >
> >Ideally I want:
> >
> >username(at)host:database $
> >
> >as the prompt. Anyone got any ideas/references?
> >
> >
> >
>
> Put
> \set PROMPT1 '%n(at)%m:%~%R%# '
> in your .psqlrc file.
I've just looked in the manpage - does anyone know where psql looks for
a system-wide psqlrc?
--
Sam Barnett-Cormack
Software Developer | Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark | 2003-09-02 10:28:02 | oids |
| Previous Message | Renney Thomas | 2003-09-02 08:12:45 | Re: language "plpgsql" does not exist |