How to Fix panic: sql: unknown driver “postgres” (forgotten import?)

by

The panic: sql: unknown driver “postgres” occurs in Go when you try to use the “postgres” driver in your SQL-related code, but the driver cannot be found. This is likely because the PostgreSQL driver for your programming language has not been installed or imported correctly.

To fix the panic: sql: unknown driver “postgres”, you need to install and import the “pq” package, the PostgreSQL driver for Go.

To install the package, run the following command in your terminal.

go get github.com/lib/pq

Then, in your Go code, ensure to import the package:

import (
  "database/sql"
  _ "github.com/lib/pq"
)

The underscore (_) is used as an alias to import the package for its side effects only (registering the “postgres” driver).

That’s it.