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
