| From: | "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net> |
|---|---|
| To: | Bernie Huang <bernie(dot)huang(at)ec(dot)gc(dot)ca> |
| Cc: | PHP_DB <php-db(at)lists(dot)php(dot)net>, PHP_General <php-general(at)lists(dot)php(dot)net>, PGSQL-SQL <pgsql-sql(at)postgresql(dot)org>, PGSQL-GENERAL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [SQL] a script that queries database periodically |
| Date: | 2000-11-27 19:44:25 |
| Message-ID: | Pine.LNX.4.30.0011271442400.3427-100000@chapelperilous.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mathijs Brands | 2000-11-27 19:44:44 | Re: [SQL] a script that queries database periodically |
| Previous Message | Folke Ashberg | 2000-11-27 19:38:40 | Re: [PHP] a script that queries database periodically |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mathijs Brands | 2000-11-27 19:44:44 | Re: [SQL] a script that queries database periodically |
| Previous Message | Folke Ashberg | 2000-11-27 19:38:40 | Re: [PHP] a script that queries database periodically |