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@host:database $
>
>as the prompt. Anyone got any ideas/references?
>
>
>
Put
\set PROMPT1 '%n@%m:%~%R%# '
in your .psqlrc file.