On Fri, Apr 17, 2009 at 3:00 AM, Sergio Chavarria <sergio.chavarria@xxxxxxxxx> 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" -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
