go lang连接操作pg数据库 简单示例

package main

import (
"database/sql"
_ "github.com/lib/pq" // 根据自己的文件位置设置  https://download.csdn.net/download/weixin_43542114/15133725
）
//测试连接一下 pg 数据库
func TestLilnkPgDatabase() {
	db, err := sql.Open("postgres", "user=postgres password=123456 dbname=db_test  sslmode=disable")
	if err != nil {
		fmt.Println("链接pg数据失败！ err：", err.Error())
		return
	}
	defer db.Close()
	fmt.Println("连接pg成功")
	err = db.Ping()
	if err != nil {
		fmt.Println("ping 数据出现错误！ er：", err.Error())
		return
	}
	var rows *sql.Rows
	rows, err = db.Query("select * from student")
	if err != nil {
		fmt.Println("查询数据失败！err：", err.Error())
		return
	}
	defer rows.Close()
	for rows.Next() {
		var (
			id     int
			name   string
			score  float32
			data   time.Time
			others string
		)
		err = rows.Scan(&id, &name, &score, &data, &others)
		if err == nil {
			fmt.Println(fmt.Sprintf("id:%d;name:%s;score:%f;data:%s;others:%s", id, name, score, data, others))
		}
	}

}