Re: psql possible TODO - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: psql possible TODO
Date
Msg-id 200612052245.kB5MjDf26529@momjian.us
Whole thread Raw
In response to Re: psql possible TODO  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: psql possible TODO
List pgsql-hackers
Alvaro Herrera wrote:
> Tom Lane wrote:
> > "Joshua D. Drake" <jd@commandprompt.com> writes:
> > > control-R isn't real useful for 17 queries that are exactly the same
> > > except for 3 different join clauses. It also isn't useful when you don't
> > > know exactly what query you are looking for.
> > 
> > ... but, somehow, you know exactly what command number it has?
> 
> Well, presumably \s would give you the numbers.  "history" does on bash anyway.
> 
> I use it on bash all the time: I do "history | grep something" and then
> !<number of command I want>.
> 
> I don't think we can do the "| grep" part, but it's useful anyway.

OK, now at least I understand how it would be used, and could be
explained easily in the documentation --- do \s, then \! 99, or maybe \#
99.  I don't like making \! do shells and pull SQL commands from history.

--  Bruce Momjian   bruce@momjian.us EnterpriseDB    http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Source directory
Next
From: "Joshua D. Drake"
Date:
Subject: Re: psql possible TODO