windows安裝psycopg2問題解決方案

在windows下使用

easy_installpsycopg2安裝psycopg2時安裝成功，但在python中import psycopg2時卻提示如下錯誤：

from psycopg2._psycopg import BINARY, NUMBER, STRING, DATETIME, ROWID
ImportError: DLL load failed: 找不到指定的模組。

為何？？

 ImportError: DLL load failed: The specified module could not be found.the file _psycopg.pyd is a dll. For its relatively small size it isprobably dynamically linked to the libpq.dll. I think the systemeither fails to find libpq.dll or some of the other dependencies (theyare listed in the setup.py).
I suggest you to use a tool to check its dll dependencies (maybehttp://www.dependencywalker.com/ could be ok) and see if there isanything missing. If libpq.dll is the missing one, try putting it in aPATH directory or in the psycopg2 package directory.
具體解決方案如下：
尋找libpq.dll，將其copy到psycopg2的包中，或者放置在系統PATH下即可