psycopg2模块

最新推荐文章于 2022-11-29 09:31:20 发布

limengyu900

最新推荐文章于 2022-11-29 09:31:20 发布

阅读量188

点赞数

分类专栏： Python 文章标签： python

本文链接：https://blog.csdn.net/limengyu900/article/details/84700923

版权

Python 专栏收录该内容

5 篇文章 0 订阅

订阅专栏


#!/usr/bin/python
#-*-coding:utf-8-*- 
import psycopg2
# 数据库连接参数
conn = psycopg2.connect(database="newdb", user="admin", password="admin", host="192.168.0.43", port="5432")
cur = conn.cursor()
cur.execute("CREATE TABLE test(id serial PRIMARY KEY, num integer,data varchar);")
cur.execute("INSERT INTO test(num, data)VALUES(%s, %s)", (1, 'aaa'))
cur.execute("INSERT INTO test(num, data)VALUES(%s, %s)", (2, 'bbb'))
cur.execute("INSERT INTO test(num, data)VALUES(%s, %s)", (3, 'ccc'))
cur.execute("SELECT * FROM test;")
rows = cur.fetchall()      
print(rows)
for i in rows:
    print(i)
conn.commit()
cur.close()
conn.close()