bat BAT Files: Execute Multiple Commands in a Loop One of the tasks the other day was to load a large DB organised by year. The most efficient way was to loop through a sequence of years and execute the loader for each one. The first iteration I ended with was: FOR /L %%Y IN (1996,1,2008) DO
call PostgreSQL: Call a Stored Procedure for Every Row I guess that newbies in PostgreSQL like me have first question when they create a store procedure: How do I call it? The answer is simple; you just execute SELECT your_procedure_name(parameters); Then, usually immediately the second question pops up: I wrote a procedure which I need to