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
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

pg

package module

Go to main page

Versions in this module

v1

v1.1.2

Jan 13, 2026

v1.1.1

Jan 11, 2026

Changes in this version

+ const TraceSpanNameArg

+ func NewOTELTracer(t trace.Tracer) *tracer

type Opt

+ func WithTracer(tracer trace.Tracer) Opt

type Queries

+ func (s *Queries) Query(key string) string

v1.1.0

Jan 10, 2026

Changes in this version

type Conn

+ WithQueries func(...*Queries) Conn

type Opt

+ func WithApplicationName(name string) Opt

+ func WithSchemaSearchPath(schemas ...string) Opt

+ type Queries struct

+ func NewQueries(r io.Reader) (*Queries, error)

+ func (s *Queries) Get(key string) string

+ func (s *Queries) Keys() []string

v1.0.16

Dec 17, 2025

v1.0.15

Dec 17, 2025

v1.0.14

Dec 17, 2025

v1.0.13

Dec 17, 2025

v1.0.12

Dec 16, 2025

v1.0.11

Dec 16, 2025

v1.0.10

Dec 15, 2025

v1.0.9

Dec 15, 2025

v1.0.8

Dec 15, 2025

Changes in this version

+ const DefaultPort

+ func NewTracer(fn TraceFn) *tracer

+ func SchemaCreate(ctx context.Context, conn Conn, name string) error

+ func SchemaDrop(ctx context.Context, conn Conn, name string) error

+ func SchemaExists(ctx context.Context, conn Conn, name string) (bool, error)

+ type Bind struct

+ func NewBind(pairs ...any) *Bind

+ func (bind *Bind) Append(key string, value any) bool

+ func (bind *Bind) Copy(pairs ...any) *Bind

+ func (bind *Bind) Del(key string)

+ func (bind *Bind) Exec(ctx context.Context, conn pgx.Tx, query string) error

+ func (bind *Bind) Get(key string) any

+ func (bind *Bind) Has(key string) bool

+ func (bind *Bind) Join(key, sep string) string

+ func (bind *Bind) MarshalJSON() ([]byte, error)

+ func (bind *Bind) Query(ctx context.Context, conn pgx.Tx, query string) (pgx.Rows, error)

+ func (bind *Bind) QueryRow(ctx context.Context, conn pgx.Tx, query string) pgx.Row

+ func (bind *Bind) Replace(query string) string

+ func (bind *Bind) Set(key string, value any) string

+ func (bind *Bind) String() string

+ type Conn interface

+ Bulk func(context.Context, func(Conn) error) error

+ Delete func(context.Context, Reader, Selector) error

+ Exec func(context.Context, string) error

+ Get func(context.Context, Reader, Selector) error

+ Insert func(context.Context, Reader, Writer) error

+ List func(context.Context, Reader, Selector) error

+ Remote func(database string) Conn

+ Tx func(context.Context, func(Conn) error) error

+ Update func(context.Context, Reader, Selector, Writer) error

+ With func(...any) Conn

+ type Err int

+ const ErrBadParameter

+ const ErrNotAvailable

+ const ErrNotFound

+ const ErrNotImplemented

+ const ErrSuccess

+ func (e Err) Error() string

+ func (e Err) With(a ...any) error

+ func (e Err) Withf(format string, a ...any) error

+ type ListReader interface

+ ScanCount func(Row) error

+ type Listener interface

+ Close func(context.Context) error

+ Listen func(context.Context, string) error

+ Unlisten func(context.Context, string) error

+ WaitForNotification func(context.Context) (*Notification, error)

+ type Notification struct

+ Channel string

+ Payload []byte

+ type OffsetLimit struct

+ Limit *uint64

+ Offset uint64

+ func (r *OffsetLimit) Bind(bind *Bind, max uint64)

+ func (r *OffsetLimit) Clamp(len uint64)

+ type Op uint

+ const Delete

+ const Get

+ const Insert

+ const List

+ const None

+ const Update

+ func (o Op) String() string

+ type Opt func(*opt) error

+ func WithAddr(addr string) Opt

+ func WithBind(k string, v any) Opt

+ func WithCredentials(user, password string) Opt

+ func WithDatabase(name string) Opt

+ func WithHostPort(host, port string) Opt

+ func WithSSLMode(mode string) Opt

+ func WithTrace(fn TraceFn) Opt

+ func WithURL(value string) Opt

+ type PoolConn interface

+ Close func()

+ Listener func() Listener

+ Ping func(context.Context) error

+ Reset func()

+ func NewPool(ctx context.Context, opts ...Opt) (PoolConn, error)

+ type Reader interface

+ Scan func(Row) error

+ type Row pgx.Row

+ type Selector interface

+ Select func(*Bind, Op) (string, error)

+ type TraceFn func(context.Context, string, any, error)

+ type Writer interface

+ Insert func(*Bind) (string, error)

+ Update func(*Bind) error