Re: psql: edit function, show function commands patch

I have added this to the next commit-fest.

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

Pavel Stehule wrote:
> Hello
>
> this simple patch allow to specify cursor row when some function is
> opened in editor.
>
> \e aaa.txt
> \a aaa.txt 3 ... move cursor on 3nd line of text
> \ef foo
> \ef foo 3 ... move cursor on 3nd line of function body
> \sf foo ... show function body
> \sf+ foo ... show function body - use line numbers
> \sf[+] foo n ... show function body from line n
>
> postgres=# \sf foo
>
> CREATE OR REPLACE FUNCTION public.foo()
> RETURNS integer
> LANGUAGE plpgsql
> AS $function$
> begin
> return 10/0;
> end;
> $function$
>
> postgres=# \sf+ foo
>
> **** CREATE OR REPLACE FUNCTION public.foo()
> **** RETURNS integer
> **** LANGUAGE plpgsql
> 1 AS $function$
> 2 begin
> 3 return 10/0;
> 4 end;
> **** $function$
>
> Regards
> Pavel Stehule

[ Attachment, skipping... ]

>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers

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