dbpath = /etc/postfix/private/mail.sqlite query = SELECT A1.addLocalpart || (CASE WHEN V1.vaTargetExt IS NOT NULL THEN '-' || V1.vaTargetExt ELSE '' END) || '@' || D1.domName FROM VAlias AS V1 JOIN Address AS A1 ON (V1.vaTargetNum = A1.addNum) JOIN Domain AS D1 ON (A1.addDomNum = D1.domNum) JOIN Address AS A2 ON (V1.vaNum = A2.addNum) JOIN Domain AS D2 ON (A2.addDomNum = D2.domNum) WHERE A2.addLocalpart || '@' || D2.domName IS '%s' AND V1.active!=0 # This query has the postconf value of $recipient_delimiter hardcoded: # '-' above. If you change that in main.cf you must change it here too!