使用Python将二进制文件上传到postgres服务器

import psycopg2

# 连接到PostgreSQL数据库
conn = psycopg2.connect(
    host="localhost",
    port="5432",
    database="your_database",
    user="your_username",
    password="your_password"
)

with open("your_file.bin", "rb") as file:
    data = file.read()

# 创建数据库表
cur = conn.cursor()
cur.execute("""
    CREATE TABLE IF NOT EXISTS files (
        id SERIAL PRIMARY KEY,
        name VARCHAR(255),
        data BYTEA
    )
""")
conn.commit()

# 插入二进制数据
cur.execute("""
    INSERT INTO files (name, data)
    VALUES (%s, %s)
""", ("your_file.bin", psycopg2.Binary(data)))
conn.commit()

# 关闭数据库连接
cur.close()
conn.close()