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:
[EMAIL PROTECTED]:database $
as the prompt. Anyone got any ideas/references?
Put \set PROMPT1 '[EMAIL PROTECTED]:%~%R%# ' in your .psqlrc file.
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html