pgMail 1.1 Released.
Ever need the ability to send mail from within PostgreSQL? Want more
functionality out of your database? Need to increase your customer
outreach while decreasing your engaged involvement? pgMail is the answer!
pgMail is simply a stored function written in TCL which takes 4 arguments
of type text (Who is it from, who is it to, subject, and body of message),
contacts the email server via TCL sockets, and transmits your email.
When used with triggers, pgMail can automagically send email when various
columns in records are updated, rows are inserted, or even deleted. For
instance, if you run a e-commerce website which must ship inventory,
emails can be sent when product is ordered, and then when product is
shipped.
This can be used for various closed installations which might want to
handle all email sending from the database layer if the application layer
is mixed, firewalled, or possibly just slow.
View and download this gem at http://pgmail.sourceforge.net/. Thanks!
Fair Winds and Following Seas,
Branden R. Williams <brw@brw.net>
http://www.brw.net/
--
PGP Key: http://www.brw.net/brw.asc
On Tue, 1 May 2001, Branden R. Williams wrote:
Ever need the ability to send mail from within PostgreSQL? Want more
functionality out of your database? Need to increase your customer
outreach while decreasing your engaged involvement? pgMail is the answer!View and download this gem at http://pgmail.sourceforge.net/. Thanks!
This is useful. Thanks!
(there was a pgsendmail contribution several months ago, but I could never
get it to compile, and the author seemed to drop off the face of the
earth).
Would you consider adding this the techdocs PL/pgSQL Cookbook at
techdocs.postgresql.org? People might notice it there that wouldn't see it
here.
--
Joel Burton <jburton@scw.org>
Director of Information Systems, Support Center of Washington