Re: psql: edit function, show function commands patch - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: psql: edit function, show function commands patch
Date
Msg-id 201003312238.o2VMcZB14996@momjian.us
Whole thread Raw
In response to psql: edit function, show function commands patch  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: psql: edit function, show function commands patch
List pgsql-hackers
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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers

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


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Parameter name standby_mode
Next
From: Bruce Momjian
Date:
Subject: Re: Questions about 9.0 release note