provided by: 
Originally published at Internet.comThe purpose of this article is to show you how to connect to PostgreSQL (pgsql) from 32 bit Windows platforms (9X, NT, and 2000). This is important because for the time being the Windows platform outnumbers Linux on the desktop and as software developers we are more likely to be able to determine the backend portions of our application. The example I'll use will consist of converting a Microsoft Access application to pgsql. It's pretty easy to extend the knowledge in this article to just about any Windows application that can access ODBC enabled information.
Before you can try these examples yourself you will have to get the Win32 ODBC driver for pgsql from ftp://ftp.postgresql.org/pub/odbc/index.html. You'll want to click the "download' link on the lower left part of the page to go to the download section. There are caveats listed on the pages about which platforms the ODBC driver will work with. I've personally used this driver on NT Workstation and Server as well as Windows 2000 Professional without problem. You will have to download and install the driver before you can continue with the examples provided in the rest of the article. If you're interested in what makes an ODBC driver tick you will most certainly want to download the LGPL'ed source code as well...
Read article at Internet.com site