Alvaro Herrera wrote: > 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.
Actually to be fair, there was no agreement. However, I do think it is not worthwhile to be a TODO (thank you anyway Bruce). I am not going to be spending my time on it and I doubt anyone else will. Joshua D. Drake > > >> --------------------------------------------------------------------------- >> >> 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? > > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster