Help us shape the future of Go! Take the 2026 Go Developer Survey

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

Go to main page

Versions in this module

v1

v1.40.0

Oct 26, 2026

v1.39.1

Oct 25, 2026

v1.39.0

Oct 25, 2026

Changes in this version

+ func Migrate(ctx context.Context, pool *pgxpool.Pool, schema string) error

+ func MigrateDB(ctx context.Context, db *sql.DB, schema string) error

+ func Validate(ctx context.Context, pool *pgxpool.Pool, schema string) error

+ type Config struct

+ AppView *notify.AppView

+ Origins []notify.OriginScope

+ Schema string

+ Scope string

+ type LegacyScope struct

+ Schema string

+ Scope string

+ type LegacyVisibility struct

+ AppID string

+ Origin notify.OriginScope

+ Visibility notify.Visibility

+ type Store struct

+ func New(pool *pgxpool.Pool, cfg Config) (*Store, error)

+ func (s *Store) AppErasedRecipients(ctx context.Context, audience notify.Audience, appID string, ...) ([]notify.Recipient, error)

+ func (s *Store) Apply(ctx context.Context, mutations []notify.Mutation) error

+ func (s *Store) ApplyTx(ctx context.Context, tx pgx.Tx, mutations []notify.Mutation) error

+ func (s *Store) ClassifyLegacyOrigins(ctx context.Context, mappings []LegacyVisibility) (int64, error)

+ func (s *Store) EraseAppRecipient(ctx context.Context, r notify.Recipient, appID string, ...) error

+ func (s *Store) EraseRecipient(ctx context.Context, r notify.Recipient) error

+ func (s *Store) EraseRecipientTx(ctx context.Context, tx pgx.Tx, r notify.Recipient) error

+ func (s *Store) Get(ctx context.Context, r notify.Recipient, id string) (notify.Item, error)

+ func (s *Store) GetRecipients(ctx context.Context, rs []notify.Recipient, id string) (notify.Item, error)

+ func (s *Store) List(ctx context.Context, r notify.Recipient, o notify.ListOptions) (notify.Page, error)

+ func (s *Store) ListRecipients(ctx context.Context, recipients []notify.Recipient, o notify.ListOptions) (notify.Page, error)

+ func (s *Store) MergeFrom(ctx context.Context, sources []LegacyScope) error

+ func (s *Store) Publish(ctx context.Context, in notify.Input) (notify.Item, error)

+ func (s *Store) PublishTx(ctx context.Context, tx pgx.Tx, in notify.Input) (notify.Item, error)

+ func (s *Store) SetDismissed(ctx context.Context, r notify.Recipient, id string, dismissed bool) (notify.Item, error)

+ func (s *Store) SetDismissedRecipients(ctx context.Context, rs []notify.Recipient, id string, dismissed bool) (notify.Item, error)

+ func (s *Store) SetRead(ctx context.Context, r notify.Recipient, id string, read bool) (notify.Item, error)

+ func (s *Store) SetReadRecipients(ctx context.Context, rs []notify.Recipient, id string, read bool) (notify.Item, error)

+ func (s *Store) Transition(ctx context.Context, r notify.Recipient, id string, revision int64, ...) (notify.Item, error)

+ func (s *Store) TransitionTx(ctx context.Context, tx pgx.Tx, r notify.Recipient, id string, revision int64, ...) (notify.Item, error)