functions in postgresql

Started by Stewart, Robert D (COT)over 21 years ago3 messagesgeneral
Jump to latest
#1Stewart, Robert D  (COT)
RobertD.Stewart@ky.gov

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

#2Joshua D. Drake
jd@commandprompt.com
In reply to: Stewart, Robert D (COT) (#1)
Re: functions in postgresql

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
#3Pavel Stehule
pavel.stehule@gmail.com
In reply to: Stewart, Robert D (COT) (#1)
Re: functions in 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:

Show quoted text

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