从golang查询Postgres复合类型

go get github.com/lib/pq

go get github.com/jackc/pgx/v4

package main

import (
	"database/sql"
	"fmt"

	_ "github.com/lib/pq" // 或者使用 _ "github.com/jackc/pgx/v4"
)

type Person struct {
	ID   int
	Name string
	Age  int
}

func main() {
	// 连接到PostgreSQL数据库
	db, err := sql.Open("postgres", "host=localhost port=5432 user=your_username password=your_password dbname=your_database sslmode=disable")
	if err != nil {
		panic(err)
	}
	defer db.Close()

	// 查询复合类型
	rows, err := db.Query("SELECT * FROM your_table")
	if err != nil {
		panic(err)
	}
	defer rows.Close()

	var people []Person

	// 遍历查询结果
	for rows.Next() {
		var person Person
		err := rows.Scan(&person.ID, &person.Name, &person.Age)
		if err != nil {
			panic(err)
		}
		people = append(people, person)
	}

	// 打印查询结果
	for _, person := range people {
		fmt.Printf("ID: %d, Name: %s, Age: %d\n", person.ID, person.Name, person.Age)
	}
}