Re: Need psql send email - Mailing list pgsql-general

Hi All, I am new to postgresql. I want to send email by using pl pgsql. I want to know how to set up the configurations for mail server. Can any one help me in solving this?. [hidden email]

---

View this message in context: Need psql send email
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Dear friend,

I don't know if it is possible. But my experience with MS SQL Server (integration with OutLook) introduces hundreds of flaws (including crashes) into the database.
How did I accomplish this task:

a) To notify backups and so, I've configured my Cron task to do that (it is fairly easy and well documented)

b) To notify about business tasks of my applications, my applications send the e-mail (in my case, I do use Java, so I use standard JavaMail API that does everything in a snap without any flaws for years now). I believe every language in the world has similar stable APIs for sending e-mails

c) If I need to send e-mail based on database events (like a trigger), I use a "Queue Table" where I insert messages that need to be sent, and have external application that (from time to time) checks this table for new messages to be sent.


I hope this ideas help you.

Regards,

Edson.