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