I am interested in having a PostgreSQL query run and some email
sent on an automatic basis. Doesnt seem like trigger does this
sort of thing and I didnt see any reference to sending email
in a couple PostgreSQL books.

My host system is Redhad 8, Apache, Postfix, PHP and Perl.
I could add another scripting language if needed. Shell
is bash.

A web search turned up a couple references from 2000 and
2001 like pqmail. Is there any thing more recent that is adpated
to current versions of php and PostgreSQL?

Thanks,
Tom

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

dstaal

--As off Sunday, November 16, 2003 11:25 AM -0800, hodges@xprt.net is
alleged to have said:


--As for the rest, it is mine.

I'd write a Perl script that runs the query and sends the email, then
set a cron job to run the script. Should be fairly simple, look at
CPAN for MAIL:: modules that you can use to help with sending the
email.

Daniel T. Staal

---------------------------------------------------------------
This email copyright the author. Unless otherwise noted, you
are expressly allowed to retransmit, quote, or otherwise use
the contents for non-commercial purposes. This copyright will
expire 5 years after the author's death, or in 30 years,
whichever is longer, unless such a period is in excess of
local copyright law.
---------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html