| From: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Suresh Raja <suresh(dot)rajaabc(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: [SQL] function to send email with query results |
| Date: | 2015-04-18 22:42:01 |
| Message-ID: | 5532DDB9.4070507@BlueTreble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
On 4/18/15 12:52 AM, David G. Johnston wrote:
> On Friday, April 17, 2015, Suresh Raja <suresh(dot)rajaabc(at)gmail(dot)com
> <mailto:suresh(dot)rajaabc(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andomar | 2015-04-19 09:24:16 | Re: Waiting on ExclusiveLock on extension |
| Previous Message | Jim Nasby | 2015-04-18 22:40:44 | Re: ORDER BY for jsonb |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anil Menon | 2015-04-19 15:59:07 | Re: [SQL] function to send email with query results |
| Previous Message | Andreas Kretschmer | 2015-04-18 11:04:32 | Re: function to send email with query results |