Re: Schedule DB Query

On Fri, Apr 17, 2009 at 3:00 AM, Sergio Chavarria
<sergio.chavarria@gmail.com> wrote:

> Hi, i hope someone can help me in this mailing list. Is there a way to
> schedule databases querys with postgresql?? Ideally i would like to have a
> database table with one field containing database queries and then create a
> "postgres cron"  for executing all my queries at a specified time.
>
> I know one possible solution would be to create a cron in unix but i think
> it would be better if i can create it within the database so, if i change my
> system, i can keep this information just doing a "pgdump" and restoring  in
> another system.

I would go for a cron job that calls a script that launches a number
of SQL commands through psql -c or pgsql -f.

--
Jaume Sabater
http://linuxsilo.net/

"Ubi sapientas ibi libertas"