Postgres Pro
Downloads
Home   >   mailing lists

Re: Stored procedure in PostgreSQL - Mailing list pgsql-general

From Jean-Michel POURE
Subject Re: Stored procedure in PostgreSQL
Date
Msg-id 200203131639.g2DGdeVc005635@www1.translationforge
Whole thread Raw
In response to Stored procedure in PostgreSQL  (rrozboril@goldmann.sk (Robert))
List pgsql-general
Tree view 
Le Mercredi 6 Mars 2002 10:37, Robert a écrit :
> I would like to start stored procedure (function) at specific time and
> repeate stored procedure every day.
> Is it posible in PostgreSQl?

Run batch scripts (Windows) or cron jobs (Linux) excuting:
"psql databasename "SELECT function_foo()"
or "psql databasename < filename.sql"

Best regards,
Jean-Michel POURE

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Last Insert
Next
From: will trillich
Date:
Subject: FAQ -- 'cache lookup failed' still a puzzle