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 <[EMAIL PROTECTED]> http://www.brw.net/ -- PGP Key: http://www.brw.net/brw.asc ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
