Re: Scheduled function ?

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