On Dec 21, 2007, at 7:43 AM, Robert M. Bernabe wrote:
> Thanks for the reply. PGAgent is one option I've found but I was
> hoping somebody can suggest another way to do this that would just
> use plpgsql and maybe cron. Another method perhaps that is not
> dependent PGAgent...
You can't do this in plpgsql alone. There is no built-in facility to
make something run at some interval. If you use cron, all you need to
do is have it call your function from a shell script. Something like:
psql -d database -U user -c "select my_store_function()"
John DeSoi, Ph.D.