Skip site navigation (1) Skip section navigation (2)

Re: Sending email from PL/pgsql

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Tino Wildenhain <tino(at)wildenhain(dot)de>
Cc: Alexander Deruwe <aderuwe(at)aqs-carcontrol(dot)be>,"pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Sending email from PL/pgsql
Date: 2003-10-30 16:20:27
Message-ID: 1067530828.14031.32051.camel@camel (view raw, whole thread or download thread mbox)
Lists: 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:

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

In response to

pgsql-general by date

Next:From: Bruce MomjianDate: 2003-10-30 16:23:57
Subject: Re: dump schema schema only?
Previous:From: Tom LaneDate: 2003-10-30 15:48:48
Subject: Re: slow query performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group