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: | Raw Message | Whole Thread | 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 |