Re: Emailing a list of users when a record is entered in the database.
От | Derrick Betts |
---|---|
Тема | Re: Emailing a list of users when a record is entered in the database. |
Дата | |
Msg-id | 066101c3e7ca$728bf210$0100a8c0@BigOne обсуждение исходный текст |
Ответ на | Emailing a list of users when a record is entered in the database. (nick.tew@budgens.co.uk (Nick Tew)) |
Список | 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.tew@budgens.co.uk> To: <pgsql-novice@postgresql.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 > >
В списке pgsql-novice по дате отправления: