http://wiki.huihoo.com/wiki/?action=history&feed=atom&title=PyPgSQL 2026-06-18T08:52:06Z 本wiki的该页面的版本历史 MediaWiki 1.19.2 http://wiki.huihoo.com/wiki/?title=PyPgSQL&diff=13794&oldid=prev 2007-03-07T15:04:48Z

<p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">←上一版本</td> <td colspan='2' style="background-color: white; color:black;">2007年3月7日 (三) 15:04的版本</td> </tr><tr><td colspan="2" class="diff-lineno">第1行：</td> <td colspan="2" class="diff-lineno">第1行：</td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">pyPgSQL is a package of two modules that provide a Python DB-API 2.0 compliant interface to PostgreSQL databases. The first module, libpq, exports the PostgreSQL C API to Python. This module is written in C and can be compiled into Python or can be dynamically loaded on demand. The second module, PgSQL, provides the DB-API 2.0 compliant interface and support for various PostgreSQL data types, such as INT8, NUMERIC, MONEY, BOOL, ARRAYS, etc. This module is written in Python.</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">http://pypgsql.sourceforge.net/</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>Debian &#160;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>Debian &#160;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160; #apt-get install python2.3-pgsql</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160; #apt-get install python2.3-pgsql</div></td></tr> </table>

Allen http://wiki.huihoo.com/wiki/?title=PyPgSQL&diff=13793&oldid=prev 2007-03-07T15:04:20Z

<p></p> <p><b>新页面</b></p><div>Debian <br /> #apt-get install python2.3-pgsql<br /> su postgres<br /> createdb test<br /> python<br /> &gt;&gt;&gt; from pyPgSQL import PgSQL<br /> &gt;&gt;&gt; cx = PgSQL.connect(database=&quot;test&quot;, client_encoding=&quot;utf-8&quot;, unicode_results=1)<br /> &gt;&gt;&gt; cu = cx.cursor()<br /> &gt;&gt;&gt; cu.execute(&quot;set client_encoding to unicode&quot;)<br /> &gt;&gt;&gt; cu.execute(&quot;insert into test(v) values (%s)&quot;, (u'\x99sterreich',))<br /> &gt;&gt;&gt; cu.execute(&quot;select v from test&quot;)<br /> &gt;&gt;&gt; cu.fetchone()<br /> [u'\x99sterreich']<br /> &gt;&gt;&gt;</div>

Allen