Registry / database / lib-pq

lib-pq

JSON →

library1.12.3gogounverified

Go PostgreSQL driver for database/sql.

database

go get github.com/lib/pq

github ↗homepage ↗docs ↗

INSTALL

IMPORT

SIG · LIB-PQ

lib-pq

databasegov1.12.3

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

✓ github.com/lib/pq

Connects to PostgreSQL and queries the server version.

package main import ( "database/sql" "fmt" _ "github.com/lib/pq" ) func main() { db, err := sql.Open("postgres", "user=postgres dbname=test sslmode=disable") if err != nil { panic(err) } defer db.Close() var version string db.QueryRow("SELECT version()").Scan(&version) fmt.Println(version) }

Debug

Known issues

gotchapq does not support sql.Result.LastInsertId; use RETURNING clause instead.

fix

Use INSERT ... RETURNING id with QueryRow.

affects: >=1.0.0

Upgrade

Version history

1.12.3latest on pkg.go.dev

Audit

Dependencies

No dependency data recorded yet.

Agent activity

9 hits · last 30 days

node

Resources

githubhttps://github.com/lib/pq ↗

homepagehttps://github.com/lib/pq ↗

docshttps://pkg.go.dev/github.com/lib/pq#section-documentation ↗