For the base config tools:
sudo apt-get install unixodbc-bin unixodbc odbcinst1debian1
For Postgres
sudo apt-get install odbc-postgresql
Use the template file provided to setup the odbc driver entries:
sudo odbcinst -i -d -f /usr/share/psqlodbc/odbcinst.ini.template
And this sets up the sample DSNs. (all one line)
 sudo odbcinst -i -s -l -n adyoung-pg -f /usr/share/doc/odbc-postgresql/examples/odbc.ini.template
Then modify /etc/odbc.ini to suit your DB.
For MSSQL Server and Sybase:
 sudo apt-get install tdsodbc
sudo odbcinst -i -d -f /usr/share/doc/freetds-dev/examples/odbcinst.ini
Unfortunately, this does not have a sample ODBC setup template.
Thanks for the post, Adam! Very helpful.
ODBC Ubuntu Linux 12.04
FreeTDS latest
sudo odbcinst -i -d -f /usr/share/tdsodbc/odbcinst.ini
Pingback: ODBC Setup on Ubuntu for PostgreSQL | digitalitility