Re: Newbie question

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(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Hugo
> Sent: Wednesday, May 18, 2005 8:24 AM
> To: pgsql-general(at)postgresql(dot)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