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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
