Re: Sending email from PL/pgsql

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