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 1tiKv0-00EgU9-MH for pgsql-general@arkaria.postgresql.org; Wed, 12 Feb 2025 22:09:18 +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 1tiKuy-00FVrf-2K for pgsql-general@arkaria.postgresql.org; Wed, 12 Feb 2025 22:09:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tiKux-00FVpj-Mj for pgsql-general@lists.postgresql.org; Wed, 12 Feb 2025 22:09:16 +0000 Received: from mail-pj1-x1036.google.com ([2607:f8b0:4864:20::1036]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tiKuw-000TGc-19 for pgsql-general@postgresql.org; Wed, 12 Feb 2025 22:09:15 +0000 Received: by mail-pj1-x1036.google.com with SMTP id 98e67ed59e1d1-2fa2c456816so431756a91.1 for ; Wed, 12 Feb 2025 14:09:14 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=alm.com; s=google; t=1739398153; x=1740002953; darn=postgresql.org; h=content-transfer-encoding:in-reply-to:content-language:references :cc:to:subject:from:user-agent:mime-version:date:message-id:from:to :cc:subject:date:message-id:reply-to; bh=r+4Gd+j4vRrJ87xYZ9OQlTVulSDxJILQnrTVfAzNWtI=; b=rAaiciKSQjTXd6QP4AZf/G6ItAGLXniS+NxgKksuhxS6v+eU9s5SWN6bpaWj5ddzOL 7GrBBUjovCA1GCjNJBeeDQpPgeKn44+udSgJD2qRBgW3HG3mzClxxSp+u8A4Q0DQNJ7w zWjTfQbLYYSEuOjBAXA7MKBpg/gFyQzqPgx+YBZqDJf271aqOweFn5TrKCcck/rhjgMT Pu//kywDbLeibOla9mt3Gg8NIxtUQGikRnMEmZ+CSKhDmp6U8YhgacrtfdPB1RmT9P3u b6WH6jgCzAKs7TpqbsU2GB34qHXKswZtx9lPy+IUyma9XKzQUBxGi8uX0PxDVL/R2gr7 juDg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1739398153; x=1740002953; h=content-transfer-encoding:in-reply-to:content-language:references :cc:to:subject:from:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=r+4Gd+j4vRrJ87xYZ9OQlTVulSDxJILQnrTVfAzNWtI=; b=ZamshP4o3SuT3dDJn1S4MOseVcldrXnCMl1+MN/XHTdkd1zEbkIy5UGR40aonLEsz/ 7Af4C0xUGMhV3bwrbdP61HV956P49FnGlIBVdQby8TrjrEonM+Y1W+uqtG8rczh3y3OW ZORZ9CIadK0PrDDy+g5rcuS/qkiEqo1cXQuTyPsaevEqN/pKfAN1+og9QNqvHdJYa6yU lQk87jXJJD7AJj88gNOzMlGx+1VqUiFoq0DpTY+Hfnt97hVBIUdFFk6MLOM6ENlEWaXD wwi85lMeFf7YyROJt32jLrF3jlFNwVn0vhv9+AbpDVkn9ES9BrgpnApRtqckGqeTropI NxKg== X-Gm-Message-State: AOJu0Yy1Im7vGujeQiuh/EwrNFu0oFPWdfXi4jPnUMrx9Yw3p3O1Iq5R v+scczEt7erFdOS+yBmCy1G6OnzjsuqoOxT14aOOgqhvn2Jbz45uOalKtiAKkuWEvggBPGzTWvf 9g3bNwosKCDqJhNwrHI66PSTdc6vPU3Y/o+HYlsg0/GZJJ2P6TQ9dMnzF202UIQJ1pJJp45lV9z EpIUL7PtDxKSktmDqBIdprcxvZJjPhLfHZBsTxQPag X-Gm-Gg: ASbGncthB1chJXIvuQWo2InIBeRMPNsze88U8HMigPEtD6hx4rGt/XyoNU3F1D67XCv DksmNCgiHMW4WV+zkSS/ikiIUrRpqppsKAcrnl4x0d5oKE1Hy9v75c7J0oXAYmNqzc2jihHeYlF YmeSOQo8lV0cSxc7O9gpMlfjpS5Nms8niCGPuGtqt9rsAySzlQrhEyo/z94GelLNYOUO2PNghQ6 7cMrwKJeJYnPbNPGc1fHQb+7mDHtcHEvQsPX83vtJKFXp3sBDA6yyhgKCGU7bo16AYel+95D2X5 jtQbQw+NKY5Mxl44Lv7IPRD7HaX3+akY X-Google-Smtp-Source: AGHT+IHgzQgnY0lhqnv7kM4cbXalmFhBjOCXTanlC1zvmfPYzEIHe37Q6sFWtox3Hx0Fihy51Bc6wQ== X-Received: by 2002:a17:90b:2683:b0:2f4:434d:c7f0 with SMTP id 98e67ed59e1d1-2fc0e2c285bmr1429309a91.12.1739398153432; Wed, 12 Feb 2025 14:09:13 -0800 (PST) Received: from [10.15.243.124] ([150.195.207.11]) by smtp.gmail.com with ESMTPSA id 98e67ed59e1d1-2fbf98d3dd5sm1999664a91.26.2025.02.12.14.09.12 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 12 Feb 2025 14:09:13 -0800 (PST) Message-ID: <8efb6910-0332-4794-86b8-8375daed1159@alm.com> Date: Wed, 12 Feb 2025 14:09:09 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird From: Ben Hancock Subject: Re: psql command line editing To: pgsql-general Cc: Rich Shepard References: <61255ab-6249-1226-7db6-4ecc3e4c127b@appl-ecosys.com> <3370941.1739388555@sss.pgh.pa.us> <40bef2b1-62a1-ed-63c0-6487bbcdd133@appl-ecosys.com> Content-Language: en-US In-Reply-To: <40bef2b1-62a1-ed-63c0-6487bbcdd133@appl-ecosys.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2/12/2025 11:44, Rich Shepard wrote: > I run psql from a urxvt virtual console, not emacs (which is where I > write scripts.) As with everything in Emacs, there's a mode for that. In case you're not aware of it, sql-mode allows you not only to interact with psql from within Emacs, but also to write SQL queries in a buffer and then send the whole buffer or the region. It's not documented in the info pages, but from within Emacs, one of these should get you started: C-h P sql M-x sql-help Or just do: M-x sql-postgres - Ben