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: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] 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