Re: [SQL] a script that queries database periodically

Поиск
Список
Период
Сортировка
От Brett W. McCoy
Тема Re: [SQL] a script that queries database periodically
Дата
Msg-id Pine.LNX.4.30.0011271442400.3427-100000@chapelperilous.net
обсуждение исходный текст
Список pgsql-general
On Mon, 27 Nov 2000, Bernie Huang wrote:

> I was thinking of writing up a PHP script and put into crontab, which is
> somehow easier than a shell script, but PHP is an apache module, so I
> cannot execute PHP under crontab (it has to be executed in a browser
> right?).  I guess a shell script is necessary.  So, is it possible to
> call 'psql' and returning its query result and I can use sendmail to
> email the result? Any other idea?

Is there any reason to not use Perl & DBI or the Pg.pm module?

Brett W. McCoy
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
Exhilaration is that feeling you get just after a great idea hits you,
and just before you realize what is wrong with it.


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Indexing for geographic objects?
Следующее
От: Nelio Alves Pereira Filho
Дата:
Сообщение: Rules