| From: | "Marin Dimitrov" <marin(dot)dimitrov(at)sirma(dot)bg> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org>, "Robert" <rrozboril(at)goldmann(dot)sk> |
| Subject: | Re: Stored procedure in PostgreSQL |
| Date: | 2002-03-13 13:41:08 |
| Message-ID: | 001c01c1ca94$bb9836d0$9b0e32d4@sirma.bg |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
----- Original Message -----
From: "Robert" <rrozboril(at)goldmann(dot)sk>
> I would like to start stored procedure (function) at specific time and
> repeate stored procedure every day.
> Is it posible in PostgreSQl?
>
what about writing a script that will be executed by crond every day?
the script should contain something like:
su -l postgres -c "psql -d DBNAME -c \"select * from ..... \" "
hth,
Marin
----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lee Kindness | 2002-03-13 13:53:35 | Export a database or a table from a database |
| Previous Message | Bo Lorentsen | 2002-03-13 13:34:07 | Re: Stored procedure in PostgreSQL |