Re: psql slash# command

This has been saved for the 8.4 release:

    http://momjian.postgresql.org/cgi-bin/pgpatches_hold

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

Sibte Abbas wrote:
> On 9/9/07, Sibte Abbas <sibtay@gmail.com> wrote:
> > Attached is the patch for the TODO item mentioned at
> > http://archives.postgresql.org/pgsql-hackers/2007-09/msg00352.php
> >
> > The command has the following synopsis:
> >
> > \#: displays the command history. Like \s but prefixes the lines with line
> > numbers
> >
> > \# <line_no>: executes the command(if any) executed at the line specified by
> > line_no
> >
> > regards,
> > --
> > Sibte Abbas
> >
> >
>
> The attached patch adds the following new functionality:
>
> \#e <lineno>: Will open the command at the given lineno in an editor.
> \#e with no lineno will behave exactly like \e.
>
> Example:
> =====
>
> psql> \#
>
> 199: create or replace function foo() returns integer as $$
> begin
> return 10;
> end;
> $$language 'plpgsql';
>
> 200: select version();
>
> 201: select * from foo();
>
> \# 200
> <select version() is executed>
>
> psql> \#e 199
> <the contents of lineno 199 are opened in the editor>
>
> Definitely not for 8.3, however I hope that it can be queued for 8.4.
>
> thanks,
> --
> Sibte Abbas

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org

--
  Bruce Momjian  <bruce@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

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