Clob(长度1048576) DB2 to PostgreSQL最佳数据类型？

CREATE TABLE documents (
    id INT PRIMARY KEY,
    content CLOB(1048576)
);

CREATE TABLE documents (
    id SERIAL PRIMARY KEY,
    content TEXT -- 或 BYTEA，取决于数据类型
);

-- 假设我们使用psycopg2库进行数据迁移
import psycopg2
import ibm_db_dbi

# 连接DB2数据库
db2_conn = ibm_db_dbi.connect("DATABASE=your_db;HOSTNAME=your_host;PORT=your_port;UID=your_user;PWD=your_password;")
db2_cursor = db2_conn.cursor()

# 连接PostgreSQL数据库
pg_conn = psycopg2.connect("dbname=your_db user=your_user password=your_password host=your_host port=your_port")
pg_cursor = pg_conn.cursor()

# 查询DB2中的数据
db2_cursor.execute("SELECT id, content FROM documents")
rows = db2_cursor.fetchall()

# 插入数据到PostgreSQL
for row in rows:
    pg_cursor.execute("INSERT INTO documents (id, content) VALUES (%s, %s)", (row[0], row[1]))

# 提交事务
pg_conn.commit()

# 关闭连接
db2_cursor.close()
db2_conn.close()
pg_cursor.close()
pg_conn.close()