Thread
-
pgMail 1.1 Released.
Branden R. Williams <brw@brw.net> — 2001-05-02T02:22:15Z
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
-
Re: pgMail 1.1 Released.
Joel Burton <jburton@scw.org> — 2001-05-03T18:45:22Z
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