Re: psql possible TODO

Bruce Momjian wrote:
> 
> Added to TODO:
> 
>         o Add \# to list command history like \s, but with line numbers
> 
>          http://archives.postgresql.org/pgsql-hackers/2006-12/msg00255.php

Humm, this is not what we agreed.


> ---------------------------------------------------------------------------
> 
> Joshua D. Drake wrote:
> > Hello,
> > 
> > O.k. this is my currently thinking:
> > 
> > \#     will list just like \s except it will include line numbers:
> > 
> > 1    SELECT * FROM FOO; (not a tab of course)
> > 2    UPDATE bar SET foo = 6;
> > 
> > \# 2     will execute query number 2
> > \#e 2     will open the numbered query in $EDITOR
> > 
> > I would love to figure out a way to auto explain these queries without
> > obnoxious syntax. Any ideas?


-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support