From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: External psql editor |
Date: | 2022-04-29 17:18:20 |
Message-ID: | a2e1869f-6b6d-b2b3-9c5a-798aefbf1e17@appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, 29 Apr 2022, Francisco Olarte wrote:
> I do a similar thing, but normally edit queries in an editor window and
> just use selection or clipboard to paste them into the xterm where I have
> psql running. I also used joe a lot ( its key sequences where easy coming
> from wordstar(cp/m->msdos) ).
Francisco,
Joe can also be configured to use emacs chords which lets my fingers use the
same keys in both editors. :-)
> What do you mean by "here"? IIRC PSQL_EDITOR sets the editor for \e, not
> for the psql command line. For that you could try writing a binding for
> readline ( which you could also use in bash if you like them ) with the
> joe keyseqs, but I fear it's editing model is a nit different.
> I've done "PSQL_EDITOR=joe psql" to refresh my memory and it is in
> fact as I remembered.
>
> The use of joe AS EDITOR for a single command can be done with the above
> method. The use of joe keys for editting the normal psql line would
> probably require readline wizardry.
>
> I've read joe has slave shell sessions. Other thing you could try ( I've
> done it with emacs shell mode ) is use that, but I fear it only works well
> with single line queries. Or look if it has some kind of sql modes (
> interactive sql, not sql-script-syntax-highlight ).
Good information. Thanks. I'll dig into joe and see what's possible.
Regards,
Rich
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2022-04-29 17:27:29 | Mail list manager request |
Previous Message | Rich Shepard | 2022-04-29 17:13:09 | Re: External psql editor |