How to Connect to PostgreSQL from Go

Database

2026-04-17T12:05:42+00:00

Connect to PostgreSQL from Go using the pgx library's Connect function with a valid connection string.

Use the pgx library to connect to PostgreSQL by calling pgx.Connect with a connection string containing your host, port, user, password, and database name.

package main

import (
	"context"
	"log"

	"github.com/jackc/pgx/v5"
)

func main() {
	conn, err := pgx.Connect(context.Background(), "host=localhost port=5432 user=postgres password=postgres dbname=pgx_test")
	if err != nil {
		log.Fatal(err)
	}
	defer conn.Close(context.Background())
}