From: | "Poul L(dot) Christiansen" <poulc(at)cs(dot)auc(dot)dk> |
---|---|
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 21:44:39 |
Message-ID: | 3A22D5C7.2030502@cs.auc.dk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
I have a bash script in crontab with the following line:
"lynx -dump
http://127.0.0.1/postgres/myPhpFile.php>${currentDir}php_output.html"
You can also just put that line directly into crontab.
Poul L. Christiansen
Bernie Huang wrote:
> Hello,
>
> My boss wants me to write a script that will send a email report to him
> monthly with the result of database queries.
>
> For example, an email would be like:
>
> Monthly report
> +----------+---------+---------------+
> | Vehicles | Mileage | # of Signouts |
> +----------+---------+---------------+
> | Vehicle1 | 10324 | 5 |
> +----------+---------+---------------+
> | Vehicle2 | 19384 | 6 |
> +----------+---------+---------------+
> ...
>
> 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?
>
> Thanks.
>
> - Bernie
>
From | Date | Subject | |
---|---|---|---|
Next Message | Roberto Mello | 2000-11-27 21:56:59 | Re: [SQL] a script that queries database periodically |
Previous Message | Kenneth Been | 2000-11-27 21:15:15 | large tuple |
From | Date | Subject | |
---|---|---|---|
Next Message | Roberto Mello | 2000-11-27 21:56:59 | Re: [SQL] a script that queries database periodically |
Previous Message | Tom Lane | 2000-11-27 20:59:33 | Re: count( distinct x ) |