如何使用go-sql模拟gorm insert (postgres)

import (
    "database/sql"
    "github.com/lib/pq" // PostgreSQL驱动程序
)

db, err := sql.Open("postgres", "host=your_host port=your_port user=your_user password=your_password dbname=your_dbname sslmode=disable")
if err != nil {
    // 处理错误
}
defer db.Close()

type User struct {
    ID   int
    Name string
    Age  int
}

user := User{
    Name: "John",
    Age:  25,
}

stmt, err := db.Prepare("INSERT INTO users (name, age) VALUES ($1, $2) RETURNING id")
if err != nil {
    // 处理错误
}
defer stmt.Close()

var id int
err = stmt.QueryRow(user.Name, user.Age).Scan(&id)
if err != nil {
    // 处理错误
}

user.ID = id