Re: psql command line editing

From: Ben Hancock <bhancock(at)alm(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Cc: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Subject: Re: psql command line editing
Date: 2025-02-12 22:09:09
Message-ID: 8efb6910-0332-4794-86b8-8375daed1159@alm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2025-02-13 00:33:12 Re: Best Approach for Swapping a Table with its Copy
Previous Message Marcelo Fernandes 2025-02-12 22:04:57 Re: Best Approach for Swapping a Table with its Copy