Re: Stored procedure in PostgreSQL

From: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
To: rrozboril(at)goldmann(dot)sk (Robert), pgsql-general(at)postgresql(dot)org
Subject: Re: Stored procedure in PostgreSQL
Date: 2002-03-13 16:39:40
Message-ID: 200203131639.g2DGdeVc005635@www1.translationforge
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Le Mercredi 6 Mars 2002 10:37, Robert a écrit :
> I would like to start stored procedure (function) at specific time and
> repeate stored procedure every day.
> Is it posible in PostgreSQl?

Run batch scripts (Windows) or cron jobs (Linux) excuting:
"psql databasename "SELECT function_foo()"
or "psql databasename < filename.sql"

Best regards,
Jean-Michel POURE

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Sabino Mullane 2002-03-13 16:40:41 Re: Storing Credit Card Info?
Previous Message Stephan Szabo 2002-03-13 16:23:22 Re: Modifying text data?