使用Python在两个Postgres数据库直接复制数据

s = StringIO()

# Export into memory buffer
sql = """
    COPY (select * from foo) TO STDOUT WITH CSV HEADER ENCODING 'UTF8';
"""

sourceCursor = sourceConn.cursor()
sourceCursor.copy_expert(sql, s)

# Import from memory buffer to destination database
sql = """
    COPY bar from STDIN WITH CSV HEADER ENCODING 'UTF8';
"""
destinationCursor = destinationConn.cursor()
destinationCursor.copy_expert(sql, s)