Thread

1. psql: edit function, show function commands patch

   Pavel Stehule <pavel.stehule@gmail.com> — 2010-03-29T16:27:15Z

   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
   

2. Re: psql: edit function, show function commands patch

   Bruce Momjian <bruce@momjian.us> — 2010-03-31T22:38:35Z

   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
   
   

3. Re: psql: edit function, show function commands patch

   Pavel Stehule <pavel.stehule@gmail.com> — 2010-04-01T05:28:28Z

   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
   >