Re: Send email from PostgreSQL, may I ?

[Alvaro Herrera <alvherre(at)commandprompt(dot)com>]

Gerson Machado wrote:
> I need send email directly from PG with on function, where locate this ?

Typically this is bad idea.  Better save the email info on a table and
fire a NOTIFY.  An external daemon would be listening to that
notification, and send the email from the data in the table, which it
can subsequently delete or mark as used.

This is also better because you have a chance to retry if your SMTP is
down or whatever.  If you fail to send the mail in a trigger or
function, you have no way to wait 10 minutes without clogging your
application.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.