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

pgsql

package module

Go to main page

Versions in this module

v0

v0.10.0

Sep 28, 2026

Changes in this version

+ const ErrInvalidRoleName

+ const ErrInvalidSettingName

+ const ErrNotPostgres

+ func WithTxSession(ctx context.Context, q dbx.Querier, settings map[string]string, role string, ...) error

v0.9.1

Sep 28, 2026

v0.9.0

Sep 27, 2026

v0.8.3

Sep 20, 2026

v0.8.2

Sep 20, 2026

v0.8.1

May 14, 2026

v0.8.0

Sep 12, 2025

Changes in this version

+ const DefaultConnIdleTimeSecond

+ const DefaultConnLifeTimeSecond

+ const DefaultIdleConns

+ const DefaultMaxConns

+ const EngineMigrationTable

+ const EngineSchema

+ const ErrEmptyDSN

+ const ErrInvalidConnIdleTime

+ const ErrInvalidConnLifeTime

+ const ErrInvalidIdleConns

+ const ErrInvalidMaxConns

+ const ErrNilConfig

+ const MigrationLockId

+ const MigrationTable

+ const SchemaDefault

+ const TblTypeForeignTable

+ const TblTypeLocal

+ const TblTypeTable

+ const TblTypeView

+ func ColumnExists(ctx context.Context, client *db.SqlClient, tableName string, columnName string, ...) (bool, error)

+ func DialectOptions() *goqu.SQLDialectOptions

+ func ForeignTableExists(ctx context.Context, client *db.SqlClient, tableName string, schema string) (bool, error)

+ func GetServerVersion(db *sqlx.DB, ctx context.Context) (string, error)

+ func NewClient(config *ClientConfig) (*db.SqlClient, error)

+ func NewMigrationManager(ctx context.Context, client *db.SqlClient, opts ...PgMigrationOption) (migrations.Manager, error)

+ func TableExists(ctx context.Context, client *db.SqlClient, tableName string, schema string) (bool, error)

+ func ViewExists(ctx context.Context, client *db.SqlClient, tableName string, schema string) (bool, error)

+ type AdvisoryLock struct

+ func NewAdvisoryLock(ctx context.Context, db *sqlx.DB, id int) (*AdvisoryLock, error)

+ func (l *AdvisoryLock) Close()

+ func (l *AdvisoryLock) Lock(ctx context.Context) error

+ func (l *AdvisoryLock) TryLock(ctx context.Context) (bool, error)

+ func (l *AdvisoryLock) Unlock(ctx context.Context) error

+ type ClientConfig struct

+ ConnIdleTime int

+ ConnLifetime int

+ DSN string

+ MaxIdleConns int

+ MaxOpenConns int

+ func NewClientConfig() *ClientConfig

+ func (c ClientConfig) Apply(db *sqlx.DB) error

+ func (c ClientConfig) Validate() error

+ type LockConn interface

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

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

+ type PgMigrationOption func(s *pgMigrationManager) error

+ func WithModule(module string) PgMigrationOption

Other modules containing this package

github.com/oddbit-project/blueprint