zamri wrote:
Hi all,
I have changed my domain. So I need to act fast to all these in one go:
1. How do I add the new alias to all of my users?
2. How do i delete old aliases to all my users?
Any help appreciated.
Thx
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
1. SQL requests in DataBase whith regular expressions
example for PostgreSQL
update dbmail_aliases set alias=substring(alias,0,position('@' in
alias))||'@new.domain.org' where alias like '%@old.domain.org';
2. write script :)
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
