How To Send E-Mail From PostgreSQL

Hi ,

If you want to send E-Mails from PostgreSQL, then use the below Python 3.2 Script as below. I have used ActivePython 3.2 with PostgreSQL 9.1 for sending E-Mails from PostgreSQL.

If you want to configure the Python 3.2 with PostgreSQL 9.1 then, please refer the below steps.

http://manojadinesh.blogspot.in/2012/06/fatal-python-error-pyinitialize-unable.html

Once, your Python 3.2 successful then follow the below steps to send an e-mail.

Step 1
=====

postgres=# CREATE OR REPLACE FUNCTION public.send_email(_from Text,_password Text,smtp Text,port INT,receiver text, subject text, send_message text) RETURNS TEXT  LANGUAGE plpython3u
AS $function$

import smtplib
sender = _from
receivers = receiver
message = ("From: %s\nTo: %s\nSubject: %s\n\n %s"
 % (_from,receiver,subject,send_message))

try:

  smtpObj = smtplib.SMTP(smtp,port)
  smtpObj.starttls()
  smtpObj.login(_from, _password)
  smtpObj.sendmail(sender, receivers,message)
  print ('Successfully sent email')
except SMTPException:
  print ('Error: unable to send email')

return message
$function$
;
CREATE FUNCTION

Step 2

=====

postgres=# select send_email('dineshkumar02@gmail.com','XXPasswordXX','smtp.gmail.com',587,'dinesh.kumar@mydomain.com','Sending E-Mail From PostgreSQL','Hi,\n How do you do ..');

               send_email                

-----------------------------------------

 From: dineshkumar02@gmail.com          +

 To: dinesh.kumar@mydomain.com      +

 Subject: Sending E-Mail From PostgreSQL

(1 row)

Please check your Inbox after this function execution .. 

దినేష్ కుమార్ 

Dinesh Kumar