go_database_sql_postgres_connect_and_query_single_row.go

1package main
2
3import (
4	"database/sql"
5	"fmt"
6	"log"
7
8	_ "github.com/lib/pq"
9)
10
11func main() {
12	// Connection string parameters
13	connStr := "user=pqgotest dbname=pqgotest sslmode=verify-full"
14	
15	// Open a handle to the database
16	db, err := sql.Open("postgres", connStr)
17	if err != nil {
18		log.Fatal(err)
19	}
20	defer db.Close()
21
22	// Verify the connection is alive
23	err = db.Ping()
24	if err != nil {
25		log.Fatal(err)
26	}
27
28	// Example: Querying a single row
29	var age int
30	err = db.QueryRow("SELECT age FROM users WHERE name = $1", "John Doe").Scan(&age)
31	if err != nil {
32		log.Fatal(err)
33	}
34
35	fmt.Printf("Age is %d\n", age)
36}