Re: Send email from PostgreSQL, may I ?

Hi!

Gerson Machado wrote:

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

Alvaro Herrera wrote:

> 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.
> >
>
If you still want to send e-mails directly from PG, you can try to use my
function based on pgmail which will allow you to send e-mail using
mailservers
which require authorization and analyze relpy from smtp to be sure your
e-mail is sent (look in attachment). You will need to install pltclu first.

PS: Maybe anyone knows how to send a unicode characters in e-mail using Tcl?

Taras Kopets