| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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:
http://www.brasileiro.net/postgres/cookbook/view-one-recipe.adp?recipe_id=292
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-10-30 16:23:57 | Re: dump schema schema only? |
| Previous Message | Tom Lane | 2003-10-30 15:48:48 | Re: slow query performance |