Jim C. Nasby wrote:
> On Tue, Dec 05, 2006 at 01:13:04PM -0800, Joshua D. Drake wrote:
> > If you mean control-P as in "paste" then I would say... get your hands
> > off the mouse. The mouse is counter productive and it is faster to do
> > this:
> >
> > => \s
> > 76 SELECT * FROM Foo;
> > => !76
>
> +1. I often find myself having to edit a pasted command just to add in
> either explain or explain analyze when I'm doing performance tuning.
> Granted, this should be easier in 8.2 with the improved buffer/up-arrow
> behavior, but it's still not as handy as doing something like !42.
Hmm, what is NOT the answer to the ultimate question of Life, the
Universe and Everything? Doesn't make much sense to me ...
+1 on the !<num>, but I agree with Tom that the ! had better be a \
command (and \! is already taken).
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support