MIME-Version: 1.0
References: <61255ab-6249-1226-7db6-4ecc3e4c127b@appl-ecosys.com>
 <CANzqJaCHXvZRC6xJbxg80DoWNmm-ohFP+u=VqpsXd6wtqXXpmw@mail.gmail.com> <3370941.1739388555@sss.pgh.pa.us>
In-Reply-To: <3370941.1739388555@sss.pgh.pa.us>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Wed, 12 Feb 2025 15:03:53 -0500
Message-ID: <CANzqJaDON5n_covMuRLA2WKTxrnG_xGYENer84GAjKSWDTH+QA@mail.gmail.com>
Subject: Re: psql command line editing
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000007e4f3a062df77160"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaDON5n_covMuRLA2WKTxrnG_xGYENer84GAjKSWDTH%2BQA%40mail.gmail.com>
Precedence: bulk

--0000000000007e4f3a062df77160
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, Feb 12, 2025 at 2:29=E2=80=AFPM Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Ron Johnson <ronljohnsonjr@gmail.com> writes:
> > On Wed, Feb 12, 2025 at 1:50=E2=80=AFPM Rich Shepard <rshepard@appl-eco=
sys.com>
> > wrote:
> >> My web searches suggest that using the psql command line I'm limited t=
o
> >> moving the cursor one character at a time. Is there a way to use a sma=
ll
> >> editor, e.g., joe on linux, to move by words or to the begining and en=
d
> 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".

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

--0000000000007e4f3a062df77160
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Feb 12, 2025 at 2:29=E2=80=AFPM T=
om Lane &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt; =
wrote:</div><div class=3D"gmail_quote gmail_quote_container"><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid=
 rgb(204,204,204);padding-left:1ex">Ron Johnson &lt;<a href=3D"mailto:ronlj=
ohnsonjr@gmail.com" target=3D"_blank">ronljohnsonjr@gmail.com</a>&gt; write=
s:<br>
&gt; On Wed, Feb 12, 2025 at 1:50=E2=80=AFPM Rich Shepard &lt;<a href=3D"ma=
ilto:rshepard@appl-ecosys.com" target=3D"_blank">rshepard@appl-ecosys.com</=
a>&gt;<br>
&gt; wrote:<br>
&gt;&gt; My web searches suggest that using the psql command line I&#39;m l=
imited to<br>
&gt;&gt; moving the cursor one character at a time. Is there a way to use a=
 small<br>
&gt;&gt; editor, e.g., joe on linux, to move by words or to the begining an=
d end of<br>
&gt;&gt; the line?<br>
<br>
&gt; The PGDG prebuilt packages are built with libreadline.=C2=A0 Thus, if =
that&#39;s how<br>
&gt; you installed psql, Home, End, Ctrl-Left, Ctrl-Right and Ctrl-w should=
 work.<br>
<br>
On my machine, Ctrl-Left/Right don&#39;t seem to do anything, but<br>
the usual Emacs combinations Ctrl-A, Ctrl-E, Escape-B, Escape-F<br>
and so on work in psql.=C2=A0 I don&#39;t believe I did anything special<br=
>
to configure that.=C2=A0 Check your local readline documentation.<br>
<br>
As Adrian notes, there&#39;s also \e, which is good for entering<br>
or editing multi-line queries.<br></blockquote><div><br></div><div>There=
9;s got to be something in your shell config which says &quot;use emacs key=
s&quot; instead of &quot;use vi keys&quot;.</div></div><div><br></div><span=
 class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"g=
mail_signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauc=
e.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt=
; lobster!</div></div></div></div></div></div>

--0000000000007e4f3a062df77160--