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/
