After installing iODBC, proceed to install the PostgreSQL ODBC drivers.
Download the psqlODBC source tarball file from
Use the latest version available for download, which will be
at the bottom of the downloads page. The file will look
Extract this tarball to a temporary location, open a terminal,
and cd into that directory. The installation process is:
shell> cd the/src/directory shell> ./configure --with-iodbc --enable-pthreads shell> make shell> sudo make install
Verify the installation by confirming that the file
psqlodbcw.so is in the
Next, you must register your new ODBC Driver.
Open the iODBC Data Source Administrator application by either
iodbcadm-gtk in the
command-line, or by launching it from the
Overview page of the MySQL Workbench
Migration Wizard by clicking the Open ODBC
Go to the ODBC Drivers tab in the iODBC Data Source Administrator. It should look similar to:
Click Add a driver then fill out the form with the following values:
Description of the driver: psqlODBC
Driver file name:
Setup file name: No value is needed here
And lastly, clicking OK will complete
psqlODBC driver registration.