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 r...@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
