trigger insert/update when date changes

[JJJ777]

hi guys....

How can i trigger a function base on date changes on server.

examples:

i have 2 tables A and B :

so everyday day when the date change data will copy form table
A and insert it on Table B.

Besides set to run the file on crontab, how can i do it on postgresql ..In other words how to set the date in my table auto update when the server date changes.

tq in advance

 

[ceco]

personaly I do this type of job with crontab

there are two projects, that I know, which aim to do this functionality, but the one - didn't released any files

http://pgfoundry.org/projects/pgjob/

and the other which I don't know if it is mainteined

http://pgfoundry.org/projects/pgjob/

I havn't tried any of them (just crontab )