Re: Stored procedure in PostgreSQL

Поиск
Список
Период
Сортировка
От Marin Dimitrov
Тема Re: Stored procedure in PostgreSQL
Дата
Msg-id 001c01c1ca94$bb9836d0$9b0e32d4@sirma.bg
обсуждение исходный текст
Ответ на Stored procedure in PostgreSQL  (rrozboril@goldmann.sk (Robert))
Список pgsql-general
----- Original Message -----
From: "Robert" <rrozboril@goldmann.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. "




В списке pgsql-general по дате отправления:

Предыдущее
От: Aaron Couts
Дата:
Сообщение: vacuum with perl dbi / pg 7.1.3
Следующее
От: Bo Lorentsen
Дата:
Сообщение: Re: Stored procedure in PostgreSQL