使用Go从一个postgres数据库复制到另一个数据库

import (
    "database/sql"
    _ "github.com/lib/pq"
)

sourceDB, err := sql.Open("postgres", "source_db_connection_string")
if err != nil {
    // 处理连接错误
}

targetDB, err := sql.Open("postgres", "target_db_connection_string")
if err != nil {
    // 处理连接错误
}
defer sourceDB.Close()
defer targetDB.Close()

rows, err := sourceDB.Query("SELECT * FROM table_name")
if err != nil {
    // 处理查询错误
}
defer rows.Close()

for rows.Next() {
    var column1, column2 string
    err := rows.Scan(&column1, &column2)
    if err != nil {
        // 处理扫描错误
    }

    _, err = targetDB.Exec("INSERT INTO table_name (column1, column2) VALUES ($1, $2)", column1, column2)
    if err != nil {
        // 处理插入错误
    }
}