| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> | 
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> | 
| Subject: | psql: edit function, show function commands patch | 
| Date: | 2010-03-29 16:27:15 | 
| Message-ID: | 162867791003290927y3ca44051p80e697bc6b19de29@mail.gmail.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-hackers | 
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 | Content-Type | Size | 
|---|---|---|
| editfce.diff | application/octet-stream | 13.5 KB | 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2010-03-29 16:29:11 | Re: enable_joinremoval | 
| Previous Message | Tom Lane | 2010-03-29 16:17:54 | Re: enable_joinremoval |