Re: Send Email from Postgressql

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: brian stapel <brians_224(at)hotmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Send Email from Postgressql
Date: 2007-02-01 19:11:33
Message-ID: 20070201191133.GA2724@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Thu, Feb 01, 2007 at 08:54:34 -0600,
brian stapel <brians_224(at)hotmail(dot)com> wrote:
>
> I need to notify a user that data has changed. To accomplish this I'd like to create a trigger that watches the specified table, that on change, sends the results returned by a function in the body of an email to a specific user.

Yes this is possible to do with untrusted languages. For example you might
install perlu and write your function in that.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Burak Seydioglu 2007-02-02 02:45:38 Is setQuerySnapshot called for embedded plpgsql function calls?
Previous Message Sean Davis 2007-02-01 18:29:56 Re: query efficiency - Can I speed it up?