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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

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.

might work for you, I think.

PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng -

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-2017 The PostgreSQL Global Development Group