Re: psql command line editing

Rich Shepard <rshepard@appl-ecosys.com>

From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general <pgsql-general@postgresql.org>
Date: 2025-02-12T19:44:29Z
Lists: pgsql-general
On Wed, 12 Feb 2025, Tom Lane wrote:

> On my machine, Ctrl-Left/Right don't seem to do anything, but the usual
> Emacs combinations Ctrl-A, Ctrl-E, Escape-B, Escape-F and so on work in
> psql. I don't believe I did anything special to configure that. Check your
> local readline documentation.

Tom,

I run psql from a urxvt virtual console, not emacs (which is where I write
scripts.)

> As Adrian notes, there's also \e, which is good for entering
> or editing multi-line queries.

Often when updating table rows I'll modify one string and the row ID so I'll
learn to use \e to move around the string.

Many thanks,

Rich