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.na...@bluetreble.com> wrote: > On 4/18/15 12:52 AM, David G. Johnston wrote: > >> On Friday, April 17, 2015, Suresh Raja <suresh.raja...@gmail.com >> <mailto:suresh.raja...@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 >
