Re: Need psql send email

From: Edson Richter <edsonrichter(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Need psql send email
Date: 2012-09-20 13:35:54
Message-ID: BLU0-SMTP177A61A7C5E0546B7E489C4CF9A0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Em 20/09/2012 09:07, pavithra escreveu:
> 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]
> </user/SendEmail.jtp?type=node&node=5724700&i=0>
> ------------------------------------------------------------------------
> View this message in context: Need psql send email
> <http://postgresql.1045698.n5.nabble.com/Need-psql-send-email-tp5724700.html>
> Sent from the PostgreSQL - general mailing list archive
> <http://postgresql.1045698.n5.nabble.com/PostgreSQL-general-f1843780.html>
> 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2012-09-20 13:53:19 Re: Need psql send email
Previous Message Martin French 2012-09-20 13:19:22 Re: Need psql send email