| From: | Larry Rosenman <ler(at)lerctr(dot)org> |
|---|---|
| To: | eunice palmeira <e_palmeira(at)yahoo(dot)com(dot)br> |
| Cc: | alewis(at)themecca(dot)net, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Temporal Event |
| Date: | 2002-07-03 20:50:01 |
| Message-ID: | 1025729401.412.54.camel@lerlaptop.iadfw.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neil Conway | 2002-07-03 20:56:58 | Re: Temporal Event |
| Previous Message | Joshua D. Drake | 2002-07-03 20:46:46 | I am being interviewed by OReilly |