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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend