| From: | Devrim GUNDUZ <devrim(at)CommandPrompt(dot)com> |
|---|---|
| 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-03 20:15:59 |
| Message-ID: | 1170533759.3430.31.camel@laptop.gunduz.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hello,
On Thu, 2007-02-01 at 08:54 -0600, brian stapel 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.
http://archives.postgresql.org/pgsql-general/2006-10/msg01351.php
might work for you, I think.
Regards,
--
Devrim GÜNDÜZ
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Frank Bax | 2007-02-03 22:54:29 | Re: connection timeout? |
| Previous Message | Shoaib Mir | 2007-02-03 18:35:23 | Re: connection timeout? |