<p>Python连接示例如下：</p> <table border="0" cellpadding="0" cellspacing="0" style="width:788px"> <tbody> <tr> <td style="background-color:#f7f8fa; width:784px"> <p><span style="font-family:Consolas">import psycopg2</span></p> <p>&nbsp;</p> <p><span style="font-family:Consolas">connect_list = {&quot;host&quot;:&quot;<strong>&lt;</strong><strong>域名&gt;</strong>&quot;,</span></p> <p><span style="font-family:Consolas">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &quot;port&quot;:<strong>&lt;</strong><strong>端口&gt;</strong>,</span></p> <p><span style="font-family:Consolas">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &quot;user&quot;:&quot;username&quot;,</span></p> <p><span style="font-family:Consolas">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &quot;password&quot;:&quot; password &quot;,</span></p> <p><span style="font-family:Consolas">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &quot;dbname&quot;:&quot;<strong>&lt;Database&gt;</strong>&quot;</span></p> <p><span style="font-family:Consolas">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }</span></p> <p><span style="font-family:Consolas">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></p> <p><span style="font-family:Consolas">connect = psycopg2.connect(**connect_list)</span></p> <p><span style="font-family:Consolas"># 使用cursor()方法获取操作游标</span></p> <p><span style="font-family:Consolas">cursor=connect.cursor()</span></p> <p><span style="font-family:Consolas"># 使用execute方法执行SQL语句</span></p> <p><span style="font-family:Consolas">cursor.execute(&#39;SELECT VERSION()&#39;)</span></p> <p><span style="font-family:Consolas"># 使用 fetchone() 方法获取一条数据</span></p> <p><span style="font-family:Consolas">data = cursor.fetchone()</span></p> <p><span style="font-family:Consolas">print &quot;Database version : %s &quot; % data</span></p> <p><span style="font-family:Consolas"># 关闭数据库连接</span></p> <p><span style="font-family:Consolas">connect.close()</span></p> </td> </tr> </tbody> </table>