| 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 |