psycopg2:动态表、列和值

import psycopg2

# 连接到数据库
conn = psycopg2.connect(database="your_database", user="your_user", password="your_password", host="your_host", port="your_port")

# 创建动态表
table_name = "dynamic_table"
column_name = "dynamic_column"
data_type = "integer"
cur = conn.cursor()
cur.execute(f"CREATE TABLE {table_name} ({column_name} {data_type})")
conn.commit()

# 关闭连接
cur.close()
conn.close()

import psycopg2

# 连接到数据库
conn = psycopg2.connect(database="your_database", user="your_user", password="your_password", host="your_host", port="your_port")

# 插入动态值
table_name = "dynamic_table"
column_name = "dynamic_column"
value = 10
cur = conn.cursor()
cur.execute(f"INSERT INTO {table_name} ({column_name}) VALUES ({value})")
conn.commit()

# 关闭连接
cur.close()
conn.close()

import psycopg2

# 连接到数据库
conn = psycopg2.connect(database="your_database", user="your_user", password="your_password", host="your_host", port="your_port")

# 查询动态表和值
table_name = "dynamic_table"
column_name = "dynamic_column"
cur = conn.cursor()
cur.execute(f"SELECT * FROM {table_name}")
rows = cur.fetchall()
for row in rows:
    print(row)

# 关闭连接
cur.close()
conn.close()