Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
- API
  
  Reference documentation for the pkg.go.dev API
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

postgres

package module

Go to main page

Versions in this module

v1

v1.2.0

Jul 23, 2026

Changes in this version

+ var ErrNoRows = pgx.ErrNoRows

+ type CommandTag = pgconn.CommandTag

type DB

+ func (db *DB) Querier() Querier

+ func (db *DB) RunInTxQuerier(ctx context.Context, fn func(Querier) error, opts ...TxOption) error

+ type Querier interface

+ Exec func(ctx context.Context, sql string, args ...any) (CommandTag, error)

+ Query func(ctx context.Context, sql string, args ...any) (Rows, error)

+ QueryRow func(ctx context.Context, sql string, args ...any) Row

+ type Row = pgx.Row

+ type Rows = pgx.Rows

+ type Tx = pgx.Tx

v1.1.0

Jul 20, 2026

Changes in this version

+ func Migrate(dsn, migrationsDir string) error

+ func MigrateWithTable(dsn, migrationsDir, table string) error

v1.0.0

Jul 18, 2026

Changes in this version

+ func Retryable(err error) bool

+ type DB struct

+ func New(ctx context.Context, dsn string, opts ...Option) (*DB, error)

+ func (db *DB) Close()

+ func (db *DB) Healthy(ctx context.Context) bool

+ func (db *DB) Ping(ctx context.Context) error

+ func (db *DB) Pool() *pgxpool.Pool

+ func (db *DB) RunInTx(ctx context.Context, fn func(pgx.Tx) error, opts ...TxOption) error

+ type Option func(*config)

+ func WithConnectTimeout(d time.Duration) Option

+ func WithHealthCheckPeriod(d time.Duration) Option

+ func WithMaxConnIdleTime(d time.Duration) Option

+ func WithMaxConnLifetime(d time.Duration) Option

+ func WithMaxConns(n int32) Option

+ func WithMinConns(n int32) Option

+ func WithTracer(t pgx.QueryTracer) Option

+ func WithTxRetry(attempts int, base, max time.Duration) Option

+ type TxOption func(*txConfig)

+ func WithAttempts(n int) TxOption

+ func WithBackoff(base, max time.Duration) TxOption

+ func WithIsolation(level pgx.TxIsoLevel) TxOption

+ func WithTxOptions(o pgx.TxOptions) TxOption