# 数据库连接参数 conn = psycopg2.connect(database=database, user=user,password=password, host=host, port=port) cur = conn.cursor() cur.execute("SELECT * from user where sex=\"男\" ;") rows = cur.fetchall() # all rows in table # 将查询到的结果放入dataframe df = pd.DataFrame(rows, columns=['ID','name','sex','phone'])
