1 CREATE VIEW mta_users AS
2 SELECT user_name AS login,
7 CREATE VIEW mta_lists AS
10 '|/var/lib/mailman/mail/mailman post ' || list_name AS post_address,
11 '|/var/lib/mailman/mail/mailman admin ' || list_name AS admin_address,
12 '|/var/lib/mailman/mail/mailman bounces ' || list_name AS bounces_address,
13 '|/var/lib/mailman/mail/mailman confirm ' || list_name AS confirm_address,
14 '|/var/lib/mailman/mail/mailman join ' || list_name AS join_address,
15 '|/var/lib/mailman/mail/mailman leave ' || list_name AS leave_address,
16 '|/var/lib/mailman/mail/mailman owner ' || list_name AS owner_address,
17 '|/var/lib/mailman/mail/mailman request ' || list_name AS request_address,
18 '|/var/lib/mailman/mail/mailman subscribe ' || list_name AS subscribe_address,
19 '|/var/lib/mailman/mail/mailman unsubscribe ' || list_name AS unsubscribe_address