Once Postfix is built with pgsql support, you can specify a
map type in
main.cf like this:
/etc/postfix/
main.cf:
alias_maps =
pgsql:/etc/postfix/pgsql-aliases.cf
The file /etc/postfix/pgsql-aliases.cf specifies lots of
information telling postfix how to reference the pgsql database.
For a complete description, see the
pgsql_table(5) manual page.