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

From Shridhar Daithankar
Subject Re: Sending email from PL/pgsql
Date
Msg-id 3FA0D2EF.10605@myrealbox.com
Whole thread Raw
In response to Sending email from PL/pgsql  (aderuwe@aqs-carcontrol.be (Alexander Deruwe))
List pgsql-general
Alexander Deruwe wrote:
> 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?

You can write a postgresql function in C that calls libesmtp to send mails.

http://www.stafford.uklinux.net/libesmtp/

  Shridhar


pgsql-general by date:

Previous
From: aderuwe@aqs-carcontrol.be (Alexander Deruwe)
Date:
Subject: Sending email from PL/pgsql
Next
From: Teodor Sigaev
Date:
Subject: Re: tsearch ukrainian stemmer dict