On Thursday 04 May 2006 17:50, Daniel T. Staal wrote:
> On Thu, May 4, 2006 10:37 am, Aarni Ruuhimäki said:
> > Hi,
> >
> > What's the best / easiest way to run a function as a 'scheduled task' ?
> >
> > My current platform is FC2 / PostgreSQL 8.0.2 and the stock report
> > application is in php.
>
> Probably cron. Write a script to call the function, then have cron call
> it at appropriate times.
>
> Daniel T. Staal
>
Hi,
Yes, I thought so. What would the syntax of such a script ?
Something like:
#!/bin/bash
#
/usr/local/pgsql/bin/psql db_name
run a function ?
#eof
Cronned for user postgres.
BR,
Aarni