Re: Can we have time based triggers in Postgresql??

--- Shanmugasundaram Doraisamy <shan(at)ceedees(dot)com>
wrote:
> Dear Group,
> I would like to know if can
> have a time based
> trigger, for example a procedure that could be run
> everyday at say 10 in
> the night. Thanking you,
>
> Yours sincerely,
>
> Shan.
>

I'm not aware of any such facility in Postgres
(although I'm a relative newcomer). However, you can
easily run sql scripts using the psql commandline
tool. Combined with the cron daemon under *nix (or
the task scheduler in Windows) you should be able to
easily execute these scripts any time you want.

Regards,

Shelby Cain

__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html