python读取pgsql

#导入依赖包
#!/usr/bin/python3
import psycopg2
#创建连接对象
conn=psycopg2.connect(database="mydata",user="postgres",password="Cttic@Ais@2020",host="localhost",port="5432")
cur=conn.cursor() #创建指针对象
# 获取结果
cur.execute('SELECT mmsi FROM tb_ais_search')

#获得所有结果
results=cur.fetchall()
for row in results:
    print (row)
# 关闭练级
conn.commit()
cur.close()
conn.close()