GetDSN returns the string for connecting to the postgres instance with the parameters specified in 'opts'.

IsUniqueViolation returns true if the error is a UniqueContraintViolation.

NewDB creates a new DB.

WaitUntilReady attempts to ping the database until the context is cancelled.

WithBackOff sets the BackOff used when retrying.

WithConnMaxIdleTime sets the maximum time a database connection may be idle for.

WithConnMaxLifetime sets the maximum time a database connection may be reused for.

WithDBName sets the name for the DB.

WithHostPort sets the host and port for the DB.

WithIsolationLevel runs the transaction with the specified isolation level.

WithMaxIdleConns sets the maximum number of idle database connections to keep available for future queries.

WithMaxOpenConns sets the maximum number of concurrent database connections to be allocated before blocking new acquisitions.

WithQueryLog enables logging of SQL queries to zap at severity debug; see log.NewPGX.

WithReadOnly causes WithTx to run the transaction as read only.

WithSSLMode sets the SSL mode for connections to the database.

WithTx calls cb with a transaction, The transaction is committed IFF cb returns nil.

WithUserPassword sets the user and password for the DB.

DefaultConnMaxIdleTime is the default maximum amount of time a connection may be idle.

DefaultConnMaxLifetime is the default maximum amount of time a connection may be reused for.

DefaultMaxIdleConns is the default number of idle database connections to maintain.

DefaultMaxOpenConns is the default maximum number of open connections; if you change this, also consider changing the default from the environment in serviceenv.GlobalConfiguration.

Option configures a DB.

WithTxOption parameterizes the WithTx function.