ROUTE_QUERY = SELECT '"<+ ' || array_to_string(ARRAY(SELECT address FROM routedata WHERE enabled='t' AND name='${quote_pgsql:$domain}'),' + ') || '"' as a
SMTP_NONRAND_DOMAINS = pgsql;SELECT name FROM mtasettings WHERE name='${quote_pgsql:$domain}' \
                             AND delivery_mode=2 AND protocol=1;
SMTP_RAND_DOMAINS = pgsql;SELECT name FROM mtasettings WHERE name='${quote_pgsql:$domain}' \
                             AND delivery_mode=1 AND protocol=1;
LMTP_NONRAND_DOMAINS = pgsql;SELECT name FROM mtasettings WHERE name='${quote_pgsql:$domain}' \
                             AND protocol=2 AND delivery_mode=2;
LMTP_RAND_DOMAINS = pgsql;SELECT name FROM mtasettings WHERE name='${quote_pgsql:$domain}' \
                          AND protocol=2 AND delivery_mode=1;
SMTP_SQL_DOMAINS = pgsql;SELECT name FROM mtasettings WHERE name='${quote_pgsql:$domain}' \
                         AND protocol=1;
LMTP_SQL_DOMAINS = pgsql;SELECT name FROM mtasettings WHERE name='${quote_pgsql:$domain}' \
                         AND protocol=2;
LDAP_DOMAINS = pgsql;SELECT name FROM mtasettings WHERE name='${quote_pgsql:$domain}' \
                     AND ldap_callout='t';
SMTP_CALLBACK_DOMAINS = pgsql;SELECT name FROM mtasettings where name='${quote_pgsql:$domain}' \
                              AND smtp_callout='t';
RELAY_SQL_DOMAINS = pgsql;SELECT name FROM relaydomains WHERE name='${quote_pgsql:$domain}';
WHITELISTED_DOMAINS = pgsql;SELECT from_address FROM lists WHERE to_address='any' AND list_type=1 AND from_address='${quote_pgsql:$sender_address_domain}';
BLACKLISTED_DOMAINS = pgsql;SELECT from_address FROM lists WHERE to_address='any' AND list_type=2 AND from_address='${quote_pgsql:$sender_address_domain}';
WHITELISTED_ADDRESS = pgsql;SELECT from_address FROM lists WHERE to_address='any' AND list_type=1 AND from_address='${quote_pgsql:$sender_address}';
BLACKLISTED_ADDRESS = pgsql;SELECT from_address from lists WHERE to_address='any' AND list_type=2 AND from_address='${quote_pgsql:$sender_address}';
WHITELISTED_HOSTS = pgsql;SELECT from_address FROM lists WHERE to_address='any' AND list_type=1 AND from_address='${quote_pgsql:$sender_host_address}';
BLACKLISTED_HOSTS = pgsql;SELECT from_address FROM lists WHERE to_address='any' AND list_type=2 AND from_address='${quote_pgsql:$sender_host_address}';
RELAY_SQL_HOSTS = pgsql;SELECT address FROM relaysettings WHERE enabled='t' AND address='${quote_pgsql:$sender_host_address}';
PGSQL_SERVERS = 127.0.0.1::5432/baruwa/baruwa/verysecretpw
SPF_MSG = Please see http://www.openspf.org/Why?scope=${if def:sender_address_domain {mfrom}{helo}};identity=${if def:sender_address_domain {$sender_address}{$sender_helo_name}};ip=$sender_host_address
LDAP_LOOKUP = ${lookup pgsql {SELECT url FROM ldaplookup WHERE name='${quote_pgsql:$domain}'}}
DELIVERY_QUERY = ${lookup pgsql {INSERT INTO messagestatus (messageid, hostname, ipaddress, port, confirmation) \
                                VALUES('${quote_pgsql:$message_exim_id}', '${quote_pgsql:$dbl_delivery_fqdn}', '${quote_pgsql:$dbl_delivery_ip}', \
                                ${quote_pgsql:$dbl_delivery_port}, '${quote_pgsql:$dbl_delivery_confirmation}')}}
DEFER_QUERY = ${lookup pgsql {INSERT INTO messagestatus (messageid, hostname, ipaddress, port, confirmation, errorno, errorstr) \
                             VALUES('${quote_pgsql:$message_exim_id}', '${quote_pgsql:$dbl_delivery_fqdn}', '${quote_pgsql:$dbl_delivery_ip}', \
                             ${quote_pgsql:$dbl_delivery_port}, '${quote_pgsql:$dbl_delivery_confirmation}', ${quote_pgsql:$dbl_defer_errno}, \
                             '${quote_pgsql:$dbl_defer_errstr}')}}
DKIM_STATUS = ${lookup pgsql {SELECT name FROM maildomains,dkim_keys WHERE maildomains.id = dkim_keys.domain_id AND dkim_keys.enabled='t'}{yes}}
PASSWD_CHECK_LOGIN = SELECT password FROM users WHERE username='${quote_pgsql:$auth1}'
PASSWD_CHECK_PLAIN = SELECT password FROM users WHERE username='${quote_pgsql:$auth2}'
ORG_CHECK_LOGIN = SELECT password FROM relaysettings WHERE username='${quote_pgsql:$auth1}'
ORG_CHECK_PLAIN = SELECT password FROM relaysettings WHERE username='${quote_pgsql:$auth2}'