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:
$> cd the/src/directory $> ./configure --with-iodbc --enable-pthreads $> make $> 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 button.
Go to the ODBC Drivers tab in the iODBC Data Source Administrator. It should look similar to the example in the figure that follows.
Clickthen 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
psqlODBC driver registration.