Skip site navigation (1) Skip section navigation (2)

Re: psql possible TODO

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: psql possible TODO
Date: 2007-02-04 01:51:08
Message-ID: 200702040151.l141p8b20032@momjian.us (view raw or flat)
Thread:
Lists: pgsql-hackers
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


---------------------------------------------------------------------------

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?
> 
> 
> Sincerely,
> 
> Joshua D. Drake
> 
> 
> -- 
> 
>       === 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
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>        message can get through to the mailing list cleanly

-- 
  Bruce Momjian   bruce(at)momjian(dot)us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2007-02-04 02:38:07
Subject: Re: Bundle of patches
Previous:From: Bruce MomjianDate: 2007-02-04 01:37:33
Subject: Remove log segment and log_id fields from pg_controldata

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group