Basically you would use your operating-systems cron (or equivalent)
system.
1. Setup a query that executes the function, put it in a file;
2. add something like this to your crontab:
10 03 * * * /path-to-psql/psql < the-file-from-step-1
this would execute your at 10 minutes past 3 (in the morning), every day
(*) of every month (*) regardless of the weekday (*).
Read up on man crontab for more info.
Success,
Arian.
Robert schreef:
> I would like to start stored procedure (function) at specific time and
> repeate stored procedure every day.
> Is it posible in PostgreSQl?
>
> Thanks.
