Re: psql and readline - Mailing list pgsql-hackers

From Jean-Paul ARGUDO
Subject Re: psql and readline
Date
Msg-id 1042140075.480.6.camel@amelie
Whole thread Raw
In response to Re: psql and readline  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
On Wed, 2003-01-08 at 15:30, Christopher Kings-Lynne wrote:
> > > Is there any way of making the 'up' arrow retrieve all of the last multiline
> > > query, instead of just the last line?  It's really annoying working with
> > > large multiline queries at the moment...

You could use ledit, piped with psql works great. I use it with sqlplus
from Oracle too, adds me readline functions sqlplus doesnt have:

Under Debian GNU/Linux:

$ apt-cache search ledit   
ledit - A line editor for interactive programs.

It has some OpenCAML dependencies, beware.

After:

$ ledit | psql yourdatabase

...my 2 cents 

-- 
Jean-Paul ARGUDO
DBA PostgreSQL, MySQL, Oracle, Ingres
Membre de l'April            http://www.april.org



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Execute command type
Next
From: Tom Lane
Date:
Subject: Re: Execute command type