public inbox for [email protected]  

help / color / mirror / Atom feed

From: Ron Johnson <[email protected]>
To: pgsql-general <[email protected]>
Subject: Re: psql command line editing
Date: Wed, 12 Feb 2025 15:03:53 -0500
Message-ID: <CANzqJaDON5n_covMuRLA2WKTxrnG_xGYENer84GAjKSWDTH+QA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<CANzqJaCHXvZRC6xJbxg80DoWNmm-ohFP+u=VqpsXd6wtqXXpmw@mail.gmail.com>
	<[email protected]>

On Wed, Feb 12, 2025 at 2:29 PM Tom Lane <[email protected]> wrote:

> Ron Johnson <[email protected]> writes:
> > On Wed, Feb 12, 2025 at 1:50 PM Rich Shepard <[email protected]>
> > wrote:
> >> My web searches suggest that using the psql command line I'm limited to
> >> moving the cursor one character at a time. Is there a way to use a small
> >> editor, e.g., joe on linux, to move by words or to the begining and end
> of
> >> the line?
>
> > The PGDG prebuilt packages are built with libreadline.  Thus, if that's
> how
> > you installed psql, Home, End, Ctrl-Left, Ctrl-Right and Ctrl-w should
> work.
>
> 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.
>
> As Adrian notes, there's also \e, which is good for entering
> or editing multi-line queries.
>

There's got to be something in your shell config which says "use emacs
keys" instead of "use vi keys".

-- 
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

view thread (14+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: psql command line editing
  In-Reply-To: <CANzqJaDON5n_covMuRLA2WKTxrnG_xGYENer84GAjKSWDTH+QA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox