psql: edit function, show function commands patch

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

Responses

Browse pgsql-hackers by date

  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