Skip site navigation (1) Skip section navigation (2)

Re: Send Email from Postgressql

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 (view raw or flat)
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/


In response to

pgsql-novice by date

Next:From: Frank BaxDate: 2007-02-03 22:54:29
Subject: Re: connection timeout?
Previous:From: Shoaib MirDate: 2007-02-03 18:35:23
Subject: Re: connection timeout?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group