Re: [SQL] a script that queries database periodically

From: Mathijs Brands <mathijs(at)ilse(dot)nl>
To: "Poul L(dot) Christiansen" <poulc(at)cs(dot)auc(dot)dk>
Cc: Bernie Huang <bernie(dot)huang(at)ec(dot)gc(dot)ca>, 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 23:06:26
Message-ID: 20001128000625.B60768@ilse.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

On Mon, Nov 27, 2000 at 10:44:39PM +0100, Poul L. Christiansen allegedly wrote:
> 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

Be sure to redirect the output of the command in your crontab to /dev/null
or something similar. If you don't, the output (HTML) will be emailed to
you each time the script is run. Whether this side effect is desirable is
of course up to you (or your boss, for instance).

Getting even more off-topic,

Mathijs
--
"Where is human nature so weak as in a bookstore!"
Henry Ward Beecher (1813-1887)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John Pilley 2000-11-27 23:16:56 Cannot createdb a database I just "destroydb"'d
Previous Message Jason 2000-11-27 22:36:40 Re: [PHP-DB] Re: [SQL] a script that queries database periodically

Browse pgsql-sql by date

  From Date Subject
Next Message Alain Toussaint 2000-11-27 23:19:50 Re: Re(2): Re(2): 7.0.3 BUG
Previous Message Jason 2000-11-27 22:36:40 Re: [PHP-DB] Re: [SQL] a script that queries database periodically