SQLITE_TABLE(5) File Formats Manual SQLITE_TABLE(5) (NAME) sqlite_table - SQLite Postfix (SYNOPSIS) postmap -q "string" sqlite:/etc/postfix/filename postmap -q - sqlite:/etc/postfix/filename (DESCRIPTION) Postfix . lmdb: cdb: hash: dbm: . SQLite . Postfix "postconf -m" . SQLite SQLite main.cf : alias_maps = sqlite:/etc/postfix/sqlite-aliases.cf /etc/postfix/sqlite-aliases.cf main.cf Postfix . (LIST MEMBERSHIP) SQL $mynetworks $mydestination $relay_domains $local_recipient_maps . * * . "Postfix lists versus tables" DATABASE_README . $mydestination $relay_domains IP $mynetworks . . SQL . SQLITE (SQLITE PARAMETERS) dbpath SQLite. : dbpath = customer_database query SQL %s Postfix : query = SELECT replacement FROM aliases WHERE mailbox = '%s' '%' : %% '%' . %s . SQL (SQL quoting) (metacharacters) . %u user@domain %u (local part) SQL . %u . . %d user@domain %d SQL . . %[SUD] query . result_format ( ) . %[1-9] %1 %2 ... %9 . user@mail.example.com %1 com %2 example %3 mail . (unqualified) . domain . domain SQL . Postfix 2.2 . SQL : select_field table where_field additional_conditions. : SELECT [select_field] FROM [table] WHERE [where_field] = '%s' [additional_conditions] '%s' WHERE . Postfix 2.2 query . : query . result_format (: %s) . ( ) . '%' : %% '%' . %s . . %u user@domain %u . . %d user@domain %d . . %[SUD1-9] . query . "result_format = smtp:[%s]" mailHost transport(5) . . expansion_limit . %s . Postfix 2.2 . : (result format) ! domain (: ) "type:table". ** : 'user' "@domain" . SQLite . domain = postfix.org, hash:/etc/postfix/searchdomains SQL SQL . Postfix 2.2 . : local(8) (unqualified) . expansion_limit (: 0) ( ) . . . 1 . MAIN.CF (OBSOLETE MAIN.CF PARAMETERS) Postfix SQLite main.cf . SQLite . SQLite (_) . "sqlite:sqlitename" "query" main.cf "sqlitename_query" . (OBSOLETE QUERY INTERFACE) 2.2 Postfix . query . query . . SELECT : SELECT [select_field] FROM [table] WHERE [where_field] = '%s' [additional_conditions] %s . select_field "select" SQL. : select_field = forw_addr table "select .. from" SQL. : table = mxaliases where_field "select .. where" SQL. : where_field = alias additional_conditions SQL. : additional_conditions = AND status = 'paid' (SEE ALSO) postmap(1) Postfix postconf(5) ldap_table(5) LDAP mysql_table(5) MySQL pgsql_table(5) PostgreSQL (README FILES) "postconf readme_directory" "postconf html_directory" . DATABASE_README Postfix SQLITE_README SQLite Postfix (LICENSE) (Secure Mailer license) . (HISTORY) SQLite 2.8 Postfix . (AUTHORS) : Axel Steiner SQLITE_TABLE(5)