Schedule DB Query - Mailing list pgsql-admin

From Sergio Chavarria
Subject Schedule DB Query
Date
Msg-id 6151bf4f0904161800i49f73e33v3207497eca346aad@mail.gmail.com
Whole thread Raw
Responses Re: Schedule DB Query  (Jaume Sabater <jsabater@gmail.com>)
List pgsql-admin
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.

Maybe i am dreaming, jeje, but i want to hear the expert voices

Thank you in advance

Sergio

pgsql-admin by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: PostgreSQL vs PostgreSQL-server
Next
From: Jaume Sabater
Date:
Subject: Re: Schedule DB Query