Dear Hugo,
It is possible using cron and psql. Just "man cron" on unix if you're
not already familiar with that. The command line you should use is
something like:
psql [connection options] -f sql_commands_file.sql
Also "man psql" for the options you can use...
Starting the procedure should be done by something like:
SELECT procedure_name();
in the sql commands file given to psql.
Alternatively you can do:
echo "SELECT procedure_name();" | psql [connection options]
but I don't know how well that works with cron... I'm not actually using
it...
HTH,
Csaba.
On Wed, 2005-05-18 at 17:23, Hugo wrote:
> hi,
>
> is it possible to schedule the execution of an sql stored procedure in
> postgress on linux?
>
> thanks
>
> Hugo
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend