PG Golang

docker.bash

docker run --name some-postgres -e POSTGRES_PASSWORD=mysecretpassword -d postgres -p 5432:5432

main.go

package main

import (
	"database/sql"
	"fmt"

	_ "github.com/lib/pq"
)

func main() {
	db, err := sql.Open("postgres", "host=localhost user=postgres dbname=postgres sslmode=disable password='mysecretpassword'")
	if err != nil {
		panic(err)
	}

	rows, err := db.Query("SELECT 1;")
	if err != nil {
		panic(err)
	}

	defer rows.Close()

	for rows.Next() {
		var i int
		err := rows.Scan(&i)
		if err != nil {
			panic(err)
		}

		fmt.Printf("- %#v\n", i)
	}
}