Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tiHtJ-00Dz71-Bz for pgsql-general@arkaria.postgresql.org; Wed, 12 Feb 2025 18:55:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tiHtH-00CWIz-8W for pgsql-general@arkaria.postgresql.org; Wed, 12 Feb 2025 18:55:19 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tiHtG-00CWIh-U7 for pgsql-general@lists.postgresql.org; Wed, 12 Feb 2025 18:55:19 +0000 Received: from mail-oa1-x35.google.com ([2001:4860:4864:20::35]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tiHtF-000U9I-1M for pgsql-general@postgresql.org; Wed, 12 Feb 2025 18:55:19 +0000 Received: by mail-oa1-x35.google.com with SMTP id 586e51a60fabf-2b29662f823so33115fac.3 for ; Wed, 12 Feb 2025 10:55:17 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1739386515; x=1739991315; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=IWC0WA+VxUZE44kWopxcMIHPrDlp4tJS9U4Nj/s7Mko=; b=gPD3E8NnbVQDASw7RU+cf3DUmmeLMtVGZ0OMNEYuRmsde+IfKrbrvtR5hMoEycNfuU NxYMgXRpipvrbdxXx86Ht6GXXlA9EYhNTcSiGTn6+u/kwpCISb1Z9Syq73RIvlD7fm/B OQV289F20UcC1VDD8yJrCZKcmblkQuVJmHn4wfjy+thoSKcTKortaZG4bLlMb9bv/Qsx 1/uhnOZjDtD9ph6recLt2xU11zWwW3KZU2ilSdaOns/KVXZ4aNgtVMtAZvM9PRWzfogl +m4PwyrJd+gnY4SjFsFFRIqtq4QRQdNIresd27Dgy5P+tu/OVPG30uhOqTw+o2x4GmEe 1sNw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1739386515; x=1739991315; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=IWC0WA+VxUZE44kWopxcMIHPrDlp4tJS9U4Nj/s7Mko=; b=V/ac+0MLpmFpVv8PeWzO6Bt4v7n8o10xBAidNwHdWz/6bm0Pgau84bzcn0hOaSN8Ag ErWw30/1FHDY4RjO6VjLrAtnT6JptymhGnHY7bVCUDFexadNC/aozAjK69EeACx3bi0n AEKyN+6Uzswnat5XFrLprcFeBgk3xgRa6Jbpbz72bk3wgBqoiMdQtYD4VR/v3LOGfbFR zURvBXDgNp/ii6lXAeQOlTx+daHjx7boAXXU+EwcIK+s3P2gm1bua8gjaUDvBx1cfH39 iQ/WinyXvo/U/U0erzIN2wTASKvyVdLgNyl5T96QgCV1yBPnxe/Th2jEy2iluIJJFypq +26Q== X-Gm-Message-State: AOJu0YxbFa9tzRfmhshv56uW5DGmZjB8bUjUP44el5IE63iIt5DIIuoP jARxY/Qi/WHGTGH+AkT5bxRoMi8qlD+JaQmtnyyRmiSTww9yP+gkwN9eF/yghaAXqexz/G4VCcm hVQv2PYm81EC90A5SLTZcrunvPrw2jg== X-Gm-Gg: ASbGncsaoobC7kwCymuDRaRqczjFOkeL7BiqD6DJzLlmp7AZVVw1V7Zy65CELR/1HSQ judp7Qnf4K1uOoy2o8pHc7lLA/H5GWE729koiPf/EapvXiDvxfShClEmtrke2tZ6dQcseWa4vEw == X-Google-Smtp-Source: AGHT+IGRgTDV+uGi54mpkixXUziybIq/KBt5RQCGvSUHkmffHOiqdFbuI5maRMaD1SGfeztD7sJ7nZVn+t8nhXRW++c= X-Received: by 2002:a05:6871:612:b0:297:2763:18d4 with SMTP id 586e51a60fabf-2b8d650223cmr2407335fac.15.1739386515137; Wed, 12 Feb 2025 10:55:15 -0800 (PST) MIME-Version: 1.0 References: <61255ab-6249-1226-7db6-4ecc3e4c127b@appl-ecosys.com> In-Reply-To: <61255ab-6249-1226-7db6-4ecc3e4c127b@appl-ecosys.com> From: Ron Johnson Date: Wed, 12 Feb 2025 13:55:04 -0500 X-Gm-Features: AWEUYZntWZQ2pDJdutwZTbJmiSgSTy9bAr6R8RI-KLJ7ih33s36LyyOpHk5gwTc Message-ID: Subject: Re: psql command line editing To: pgsql-general Content-Type: multipart/alternative; boundary="0000000000005cabca062df67b37" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000005cabca062df67b37 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, Feb 12, 2025 at 1:50=E2=80=AFPM Rich Shepard 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 o= f > 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= . --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --0000000000005cabca062df67b37 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Feb 12, 2025 at 1:50=E2=80=AFPM R= ich Shepard <rshepard@appl-e= cosys.com> wrote:
My web searches sugge= st 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<= br> the line?

The PGDG prebuilt packages are bu= ilt with libreadline.=C2=A0 Thus, if that's how you installed psql, Hom= e, End, Ctrl-Left, Ctrl-Right and Ctrl-w should work.
=C2=A0
--
Death to <Redacted>, and= butter sauce.
Don't boil me, I'm still alive.
<= ;Redacted> lobster!
--0000000000005cabca062df67b37--