Thread: psql: edit function, show function commands patch
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
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
2010/4/1 Bruce Momjian <bruce@momjian.us>: > > I have added this to the next commit-fest. > thank you Pavel > --------------------------------------------------------------------------- > > 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 >