Re: function to send email with query results - Mailing list pgsql-general

From John R Pierce
Subject Re: function to send email with query results
Date
Msg-id 55320066.6030005@hogranch.com
Whole thread Raw
In response to function to send email with query results  (Suresh Raja <suresh.rajaabc@gmail.com>)
List pgsql-general
On 4/17/2015 10:30 PM, Suresh Raja wrote:
>
> 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.

I would do that in an application, not a plXXXX sql function.   make a
query, fetch the results, format them as you see fit for the email and
toss it at your language-of-choice's email facility.



--
john r pierce, recycling bits in santa cruz



pgsql-general by date:

Previous
From: Pai-Hung Chen
Date:
Subject: Re: ORDER BY for jsonb
Next
From: Jim Nasby
Date:
Subject: Re: "Cast" SRF returning record to a table type?