Sure. Just set up psql with a SQL script containing your task using a chron job.
The psql utility will accept a command file as a parameter. PostgreSQL has functions rather than stored procedures, but it works out about the same. You could also put a bunch of SQL commands that you want to run in the file that you feed to psql. > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:pgsql-general- > [EMAIL PROTECTED] On Behalf Of Hugo > Sent: Wednesday, May 18, 2005 8:24 AM > To: pgsql-general@postgresql.org > Subject: [GENERAL] Newbie question > > 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 7: don't forget to increase your free space map settings
