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

Re: Emailing a list of users when a record is entered in the database.

From: "Derrick Betts" <Derrick(at)grifflink(dot)com>
To: "Nick Tew" <nick(dot)tew(at)budgens(dot)co(dot)uk>,<pgsql-novice(at)postgresql(dot)org>
Subject: Re: Emailing a list of users when a record is entered in the database.
Date: 2004-01-31 07:18:38
Message-ID: 066101c3e7ca$728bf210$0100a8c0@BigOne (view raw or flat)
Thread:
Lists: pgsql-novice
I installed a great function called pgmail.  Then I wrote a trigger that
sends email when certain conditions are met.
see: http://sourceforge.net/projects/pgmail/

Derrick

----- Original Message ----- 
From: "Nick Tew" <nick(dot)tew(at)budgens(dot)co(dot)uk>
To: <pgsql-novice(at)postgresql(dot)org>
Sent: Tuesday, January 27, 2004 5:14 AM
Subject: [NOVICE] Emailing a list of users when a record is entered in the
database.


> Hi,
>
> I need to develop my database so when a record is entered through a
> browser, it will automatically email a list of interested parties. I
> am ok at designing the tables so the relevant personid's have the
> email address and their interested subjects. But can anybody help on
> how to email the parties when the data is passed.
>
> The only knowledge i have on this is the command
>
> "cat {filename} | mail {emailadd} -s {subject}
>
> Thanks in advance for any help
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
>


In response to

pgsql-novice by date

Next:From: Stephan SzaboDate: 2004-01-31 15:23:36
Subject: Re: 'select nextval('seq_name');' in a function ?
Previous:From: Markus BertheauDate: 2004-01-30 22:42:48
Subject: Re: Install or Bust - pgsql on Red Hat 9

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