Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security Policy
  
  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

postgresql

package

Go to main page

Versions in this module

v2

v2.7.0

Apr 24, 2024

v2.6.0

Feb 21, 2024

v2.5.0

Dec 7, 2023

v2.4.0

Nov 14, 2023

v2.3.0

Sep 4, 2023

v2.2.0

Jul 20, 2023

v2.1.0

May 31, 2023

Changes in this version

+ const DefaultMaintanenceDatabase

+ const PDriverName

+ const PSqlServerPort

+ var CreateDb = RoleOption("CREATEDB")

+ var CreateRole = RoleOption("CREATEROLE")

+ var Login = RoleOption("LOGIN")

+ var NoCreateDb = RoleOption("NOCREATEDB")

+ var NoCreateRole = RoleOption("NOCREATEROLE")

+ var NoLogin = RoleOption("NOLOGIN")

+ var NoReplication = RoleOption("NOREPLICATION")

+ var Replication = RoleOption("REPLICATION")

+ func ConnectToDB(ctx context.Context, fullservername string, database string, port int, ...) (*sql.DB, error)

+ func DatabaseExists(ctx context.Context, db *sql.DB, dbName string) (bool, error)

+ func DoesUserExist(ctx context.Context, db *sql.DB, username string) (bool, error)

+ func DropUser(ctx context.Context, db *sql.DB, user string) error

+ func FindBadChars(stack string) error

+ func GetUserServerRoles(ctx context.Context, db *sql.DB, user SQLUser) (set.Set[string], error)

+ func ReconcileUserRoleOptions(ctx context.Context, db *sql.DB, user SQLUser, desiredOptions RoleOptions) error

+ func ReconcileUserServerRoles(ctx context.Context, db *sql.DB, user SQLUser, roles []string) error

+ func RoleExists(ctx context.Context, db *sql.DB, rolname string) (bool, error)

+ func UpdateUser(ctx context.Context, db *sql.DB, user SQLUser, password string) error

+ type RoleOption string

+ type RoleOptions struct

+ CreateDb bool

+ CreateRole bool

+ Login bool

+ Replication bool

+ func GetUserRoleOptions(ctx context.Context, db *sql.DB, user SQLUser) (*RoleOptions, error)

+ type SQLRoleDelta struct

+ AddedRoles set.Set[string]

+ DeletedRoles set.Set[string]

+ func DiffCurrentAndExpectedSQLRoles(currentRoles set.Set[string], expectedRoles set.Set[string]) SQLRoleDelta

+ type SQLRoleOptionDelta struct

+ ChangedRoleOptions set.Set[RoleOption]

+ func DiffCurrentAndExpectedSQLRoleOptions(currentRoleOptions RoleOptions, expectedRoleOptions RoleOptions) SQLRoleOptionDelta

+ type SQLUser struct

+ Name string

+ func CreateUser(ctx context.Context, db *sql.DB, username string, password string) (*SQLUser, error)

+ func FindUserIfExist(ctx context.Context, db *sql.DB, username string) (*SQLUser, error)