Re: Send Email from Postgressql - Mailing list pgsql-novice

From A. Kretschmer
Subject Re: Send Email from Postgressql
Date
Msg-id 20070201150357.GI18319@a-kretschmer.de
Whole thread Raw
In response to Send Email from Postgressql  (brian stapel <brians_224@hotmail.com>)
List pgsql-novice
am  Thu, dem 01.02.2007, um  8:54:34 -0600 mailte brian stapel folgendes:
> Thanks for your time.
>
> 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.
>
> Is this possible?

Yes.

You can write such with a untrusted pl such as plperlu or plsh.
I have a function in plsh, within there i call mutt (a command-line mail
programm on linux) to send mail. The To: and other headers are
parameters.


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-novice by date:

Previous
From: brian stapel
Date:
Subject: Send Email from Postgressql
Next
From: brian stapel
Date:
Subject: Re: Send Email from Postgressql