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

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.tew (AT) budgens (DOT) co.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.



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly