Thread: Best way to test/develop lots of nested functions?
So I've got numerous plpgsql functions I have developed and have been testing using psql. I was doing fine when I was testingthe one by one, but now I need to load multiple functions at a time. Doing \i longFunctionName.sql for several functionsis a bit tedious. Any advice about how best to proceed? Is there an easy way to quickly load a batch of functions into psql? Is there a betterway than using psql? All ideas welcome. Thanks! - Leon
On Thu, Aug 05, 2010 at 09:21:00PM -0700, Leon Starr wrote: > So I've got numerous plpgsql functions I have developed and have been > testing using psql. I was doing fine when I was testing the one by one, but > now I need to load multiple functions at a time. Doing \i > longFunctionName.sql for several functions is a bit tedious. > > Any advice about how best to proceed? Is there an easy way to quickly load > a batch of functions into psql? Is there a better way than using psql? All > ideas welcome. Thanks! If you've got a bunch of functions in files you can create another file to load them. For instance, given files function1.sql, function2.sql, etc., you can create another file (which I'll call load_stuff.sql) that looks like this: \i function1.sql \i function2.sql (and so on) ...and in psql, "\i load_stuff.sql". -- Joshua Tolley / eggyknap End Point Corporation http://www.endpoint.com
Attachment
Ah, of course. Exactly what I was looking for - thanks! > > If you've got a bunch of functions in files you can create another file to > load them. For instance, given files function1.sql, function2.sql, etc., you > can create another file (which I'll call load_stuff.sql) that looks like this: > > \i function1.sql > \i function2.sql > (and so on) > > ...and in psql, "\i load_stuff.sql". > > -- > Joshua Tolley / eggyknap > End Point Corporation > http://www.endpoint.com