我正在使用psycopg3文档中的示例将一个表从一个数据库复制到另一个数据库:link
dsn_src = 'postgresql:///dev_db'
dsn_tgt = 'postgresql:///prod_test'
with psycopg.connect(dsn_src) as conn1, psycopg.connect(dsn_tgt) as conn2:
with conn1.cursor().copy("COPY sample TO STDOUT (FORMAT BINARY)") as copy1:
with conn2.cursor().copy("COPY sample FROM STDIN (FORMAT BINARY)") as copy2:
for data in copy1:
copy2.write(data)
运行此操作会导致以下错误
QueryCanceled: COPY from stdin failed: error from Python: TypeError - can't write memoryview
CONTEXT: COPY sample, line 1
正如文档所建议的，源模式和目标模式是相同的，如果删除了格式规范(FORMAT BINARY)，则此错误仍然存在.
有没有办法解决这个错误？