| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | Jorge Arangoitia Fernandez Baca <jarangoitia(at)healtechnology(dot)com(dot)pe> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Question |
| Date: | 2009-07-11 14:03:24 |
| Message-ID: | 4A589BAC.1030801@iol.ie |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 10/07/2009 21:56, Jorge Arangoitia Fernandez Baca wrote:
> I want to know if you can create a store procedure that run
> automatically after a certain time, something like a timer in java. If
> it exists, could you tell me how it is implemented??
Put your function in a file, and then create a cron job that runs psql
taking its input from the file:
psql -f <your_file> <your-database>
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jasen Betts | 2009-07-11 14:12:42 | Re: BUG #4916: wish: more statistical functions (median, percentiles etc) |
| Previous Message | Alban Hertroys | 2009-07-11 09:54:15 | Re: How to trace client sql requests? |