Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] function to send email with query results - Mailing list pgsql-sql

From Anil Menon
Subject Re: [GENERAL] function to send email with query results
Date
Msg-id CAHzbRKczJ2iyZjmM8YpbS=A_8A2AV3W-AD0ei4d2R66YdRgzRw@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] function to send email with query results  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-sql
Tree view

Using Apache camel
Listen/notify ->PGEvent Component (http://camel.apache.org/pgevent.html) -> Mail Component (http://camel.apache.org/mail.html)
You can also then handle all the exceptions of the email server easily.



On Sun, Apr 19, 2015 at 6:42 AM, Jim Nasby <Jim.Nasby@bluetreble.com> wrote:
On 4/18/15 12:52 AM, David G. Johnston wrote:
On Friday, April 17, 2015, Suresh Raja <suresh.rajaabc@gmail.com
<mailto:suresh.rajaabc@gmail.com>> wrote:

    Hi all:

    I'm looking to write a function to send email with result of a
    query.    Is it possible to send email with in a function.  Any help
    is appreciated.


Yes...though neither the neither the sql nor the plpgsql languages have
the necessary language features to do so - you will need to use
something like plperlu.

An (not mutually exclusive) alternative is to create an email queue and
write an email sending client application to process that queue.  The
main advantages being loose coupling and the ability to send the emails
asynchronously.

If you go that route you might find LISTEN/NOTIFY useful: http://www.postgresql.org/docs/9.4/static/sql-listen.html
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-sql by date:

Previous
From: Jim Nasby
Date:
Subject: Re: [GENERAL] function to send email with query results
Next
From: Shawn Gennaria
Date:
Subject: How to determine offending column for insert exceptions