Thread: functions in postgresql

Is there a way to write a function in postgresql and have the database run it on a schedule?

I would like the database to run a function on every Friday.

Thanks

Robert Stewart

Network Eng

Governor's Office of Technology

101 Cold Harbor

Work # 502 564 9696

Cell # 502 330 5991

Email RobertD.Stewart@ky.gov

RobertD.Stewart@ky.gov wrote:
> Is there a way to write a function in postgresql and have the database run
> it on a schedule?
> I would like the database to run a function on every Friday.

Use cron or windows scheduler.

J



>
>
> Thanks
>
>
>
> Robert Stewart
> Network Eng
> Governor's Office of Technology
> 101 Cold Harbor
> Work # 502 564 9696
> Cell # 502 330 5991
> Email RobertD.Stewart@ky.gov
>
>


--
Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

Hello,
You can use pgjobs-1.00.133-src.tar.gz from gbrog
http://gborg.postgresql.org/ - really confortable scheduler for
postgresql, but in C++.

Regards
Pavel

On Thu, 6 Jan 2005 RobertD.Stewart@ky.gov wrote:

> Is there a way to write a function in postgresql and have the database run
> it on a schedule?
> I would like the database to run a function on every Friday.
>
>
> Thanks
>
>
>
> Robert Stewart
> Network Eng
> Governor's Office of Technology
> 101 Cold Harbor
> Work # 502 564 9696
> Cell # 502 330 5991
> Email RobertD.Stewart@ky.gov
>
>