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