postfix/pgsql-virtual_uid_maps.cf
branchv0.6.x
changeset 486 ccdfbbb1bb01
parent 159 78b6b06188d3
child 501 f2387d60624b
equal deleted inserted replaced
485:10e9b4855173 486:ccdfbbb1bb01
     9 
     9 
    10 # The database name on the servers.
    10 # The database name on the servers.
    11 dbname = mailsys
    11 dbname = mailsys
    12 
    12 
    13 # The SQL query template used to search the database
    13 # The SQL query template used to search the database
    14 query = SELECT uid FROM postfix_uid WHERE address='%s'
    14 # Use this VIEW-based template if you didn't create the pgsql function
       
    15 # `postfix_virtual_uid_map'.
       
    16 #query = SELECT uid FROM postfix_uid WHERE address='%s'
       
    17 
       
    18 # the recommended, function-based template
       
    19 query = SELECT uid FROM postfix_virtual_uid_map('%u', '%d')