Re: session username in default psql prompt? - Mailing list pgsql-hackers

On Sat, 23 Mar 2024 at 00:34, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Prompt space is
> expensive and precious, at least for people who aren't in the
> habit of working in very wide windows.

That problem seems easy to address by adding a newline into the
default prompt. Something like this:

\set PROMPT1 '%n@%~%R%\n# '

I myself use:
\set PROMPT1 '%[%033[1m%]%M %n@%/:%>-%p%R%[%033[0m%]%\n> '