Re: Sending email from PL/pgsql - Mailing list pgsql-general

From Robert Treat
Subject Re: Sending email from PL/pgsql
Date
Msg-id 1067530828.14031.32051.camel@camel
Whole thread Raw
In response to Re: Sending email from PL/pgsql  (Tino Wildenhain <tino@wildenhain.de>)
List pgsql-general
On Thu, 2003-10-30 at 08:11, Tino Wildenhain wrote:
> Hi,
>
> Alexander Deruwe schrieb:
> > Hey,
> >
> > I was wondering if it is possible to send email from within PL/pgsql.
> > I'd like to do this to avoid code duplication in multiple frontends.
> > Can this be done somehow?  Or do I have to write a C function for this
> > purpose?  If so, how does one go about that?
> >
>
> And to make it complete, now that plpython is unrestricted,
> you can also use plpythonu for this tasks. Works very well
> since this was one of the tests I had to make just after
> I got my hands on plpythonu ;-)
>

Actually you guys left out pltclu which can do it, code can be found in
the cookbook:

http://www.brasileiro.net/postgres/cookbook/view-one-recipe.adp?recipe_id=292

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: dump schema schema only?
Next
From: "Rick Gigger"
Date:
Subject: Re: Transaction Performance Question