擅长:python、mysql、java
<p><strong>你好,mohamed mahrous,</strong></p>
<p>首先为access access PostgreSQL数据库安装psycopg2包。在</p>
<p>试试下面的代码</p>
<pre><code>import psycopg2
conn=psycopg2.connect("dbname='database1' user='postgres' password='postgres333' host='localhost' port=5433 ")
cur=conn.cursor()
def insert(table_name,name,genere,year,impd_rating):
query = "INSERT INTO "+table_name+"(name,genere,year,impd_rating) VALUES(%s,%s,%s,%s)"
try:
print query
cur.execute(query,(name,genere,year,impd_rating))
except Exception, e:
print "Not execute..."
conn.commit()
b=0
for row in DF['id']:
insert (impd_rating=float(DF['idbm_rating'][b]),year=int(DF['year'][b]),name=str(DF['name'][b]),genere=str(DF['genere'][b]),table_name='test_movies')
b= b+1
conn.close()
</code></pre>
<p></strong示例</p>
^{pr2}$
<p>我希望我的回答有帮助。<br/>
如有任何疑问请评论。在</p>