| From: | "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Stored Procedures |
| Date: | 2002-10-07 13:06:29 |
| Message-ID: | 3DA1D42D.28638.103E060A@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 7 Oct 2002 at 9:46, TomXX KubiX wrote:
> I have some stored procedures written in Pl/PgSQL. I want to run them in
> specified time. I need something as Crontab. How can I do that?
Put following in crontab as command to execute
echo "select mystoredprocedure()" | psql dbname
Same can be done via shell redirection but I use this as well..
Tweak it for additional options..
HTH
Bye
Shridhar
--
Consent decree: A document in which a hapless company consents never to commit
in the future whatever heinous violations of Federal law it never admitted to
in the first place.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christoph Dalitz | 2002-10-07 13:20:57 | Re: [pgsql-general] Daily Digest V1 #2480 |
| Previous Message | Shridhar Daithankar | 2002-10-07 12:47:53 | Re: [GENERAL] Fast Deletion For Large Tables |