| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Send Email from Postgressql |
| Date: | 2007-02-01 15:03:57 |
| Message-ID: | 20070201150357.GI18319@a-kretschmer.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | brian stapel | 2007-02-01 15:10:57 | Re: Send Email from Postgressql |
| Previous Message | brian stapel | 2007-02-01 14:54:34 | Send Email from Postgressql |