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