使用pgx.copyfrom或pgx插入GIS几何后几何。

Question

我找到了从

使用pgx.copyfromrows，

rows := [][]interface{}{
        {"John", "ST_SetSRID(ST_MakePoint(1.23,2.34), 4326)"},
        {"Jane", "ST_SetSRID(ST_MakePoint(1.10,2.12), 4326)"},
    }

    // GetSession return a *pgxpool.Pool
    copyCount, err := postgres.GetSession().CopyFrom(
        context.Background(),
        pgx.Identifier{"test_db"},
        []string{"first_name", "location"},
        pgx.CopyFromRows(rows),
    )

这使我

"ERROR: Invalid endian flag value encountered. (SQLSTATE XX000)"

使用pgx.batch：

batch := &pgx.Batch{}
    batch.Queue("insert into people(first_name, location) values($1, $2)", "Bob", "ST_SetSRID(ST_MakePoint(1.23,1.34), 4326)")
    batch.Queue("insert into people(first_name, location) values($1, $2)", "John", "ST_SetSRID(ST_MakePoint(1.23,1.34), 4326)")
    batchResult := postgres.GetSession().SendBatch(context.Background(), batch)
    _, err := batchResult.Exec()
    if err != nil {
        return rest_errors.NewInternalServerError("Error processing batch insert", err)
    }
    batchResult.Close()

我得到这个错误

Error processing batch insert - parse error - invalid geometry (SQLSTATE XX000)

db创建脚本

CREATE TABLE IF NOT EXISTS public.test_db
(
    first_name text COLLATE pg_catalog."default",
    location geometry
)

非常感谢您