Postgres Pro
Downloads
Home   >   mailing lists

Re: Can we have time based triggers in Postgresql?? - Mailing list pgsql-general

From Chris Boget
Subject Re: Can we have time based triggers in Postgresql??
Date
Msg-id 01db01c4168f$984f3a40$8c01a8c0@entropy
Whole thread Raw
In response to Can we have time based triggers in Postgresql??  (Shanmugasundaram Doraisamy <shan@ceedees.com>)
List pgsql-general
Tree view 
>                       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,

Isn't this what cron is for?  Just set it up so it invokes pg with a command
line
query.

Chris

pgsql-general by date:

Previous
From: Lincoln Yeoh
Date:
Subject: Re: PG vs MySQL
Next
From: Diogo Biazus
Date:
Subject: Wich hardware suits best for large full-text indexed databases