Scheduling in postgres

[renu]

Hi all,

I've PHP, Postgres in Linux. I would like to create a php script and schedule it to run once every 2 days or specified date and time. I could not exact info anywhere. Is there any help????

Is there any way to do a job scheduling in Postgres database as in MS- Sql server?

[Sxooter]

In the unix universe, scheduling is cron's job. If you've got root, then you can create a PHP script and place it in /etc/cron.hourly or /etc/cron.daily on a redhat box (or similar ones with /etc/cron.xxxly directories).

Start the file with:

#!/usr/local/bin/php -q
<?php

(change the path to wherever your php interpreter lives (locate bin/php will help find it.)

Look up crontab (man crontab, man cron)