Email system and PostgreSQL - Mailing list pgsql-interfaces

From Natalya S. Makushina
Subject Email system and PostgreSQL
Date
Msg-id 01BF170C.818A3CB0@makushina.rtsoft.msk.ru
Whole thread Raw
List pgsql-interfaces
Hi all!

We have database of our clients on PostgreSQL and want to send email for 
some extracts from this database. One extract is permanent list, others are 
temporary ones.
If i try to send email using triggers, email sender adress is like as 
"postgres@company.domain" . It's not right.

Also we have a mailing list manager - Majordomo.
My questions are:
1. Does any way exist to synchronize permanent list and database? May be 
using triggers.
2. Does any way exist to generate temporary list "on a fly" from database 
and to send this list to Majordomo? For example sending subscribe or 
unsubscribe email to Majorodomo.

Does anybody interest in disscussion of this problem?
Any ideas would be greatfully appreciated!
                Best regards, Natalya Makushina.



pgsql-interfaces by date:

Previous
From: Jan Dittberner
Date:
Subject: unixODBC + PostgreSQL 6.5.1
Next
From: Edouard DESSIOUX
Date:
Subject: Using php and postgres