On Wed, 2002-07-03 at 08:20, eunice palmeira wrote:
> Hi,
> I would like to trigger a rule every day in the
> specific periodic time, such as: at 12:00 pm, in
> Postgresql. But i don't know if it is possible. Help
> me please.
man crontab
Cron is your friend here. Just write a cronjob that invokes psql and
the appropriate SQL statement(s).
I do this with some of my daily maintenance stuff.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749