Documentation ¶ Index ¶ func New(opts *Opts) db.SQLClient func QueryReturningID(ctx context.Context, q db.Queryer, query string, args ...any) (int64, error) type Opts Constants ¶ This section is empty. Variables ¶ This section is empty. Functions ¶ func New ¶ func New(opts *Opts) db.SQLClient New creates a new PostgreSQL client using the provided DSN. func QueryReturningID ¶ func QueryReturningID(ctx context.Context, q db.Queryer, query string, args ...any) (int64, error) QueryReturningID executes an INSERT ... RETURNING id query and returns the inserted ID. Types ¶ type Opts ¶ type Opts struct { // DSN is a libpq connection string, e.g. // "host=localhost port=5432 dbname=kerberos user=krb password=secret sslmode=disable" // or a URL: "postgres://krb:secret@localhost:5432/kerberos?sslmode=disable" DSN string } Source Files ¶ View all Source files postgres.go Click to show internal directories. Click to hide internal directories.