I am developing a simple Go service to connect to a database for basic querying. I am using sqlc to generate the Go functions to interact with the DB. when switching the driver from lib/pq to pgx/v...

We are using a user struct with alot of fields as follow : type user struct { ID int `json:"id,omitempty"` UUID string `json:"uuid,omitempty"` Role int `json:"role,omitempty"` Name string `js...

I'm using sqlc and pgx/v5, and getting the below error for a postgres array of a user defined enum type: Error: can't scan into dest[1]: cannot scan unknown type (OID 16385) in text format into *pg...

I couldn't find it documentation how to log sql queries if I use pgx pool. For example I have created pool like this: func DB() *pgxpool.Pool { connStr := os.Getenv("DATABASE_URL") conn...

I want to scan in an array of strings using the pgx library without using pq ideally. Is there a way of doing this: sourceKeys := make([]string, 0, 1) err := rows.Scan( pq.Array(&sourceKeys), ...

I am trying to bulk insert keys in db in go here is the code Key Struct type tempKey struct { keyVal string lastKey int } Test Keys data := []tempKey{ {keyVal: "abc", lastKey: 10}, {ke...

I have the following code for connecting to a Postgres database: func connectToPostgres(ctx context.Context, url string) (*pgxpool.Pool, error) { var err error for i := 0; i < 5; i++ { p, err...

I am trying to do csv import and export data with postgresql (where the data base is at a remote host). Normally I would use the psql command to do \copy <table> from <local path> ... a...

I'm using PostgreSQL with , and I'm trying to run a SELECT * FROM query in Pgx. I can't seem to get the iteration down, as it only returns the last key in the table. I'm also trying to serve this a...

Hey I'm getting an error message : conn busy from pgx I don't know how to solve this. Here is my function : func (r *proverbRepo) SelectPendingProverbs(table string) (proverbs []domain.Proverb, e...

New at pgx. Using pgxpool. I have a simple Query var result string err := Conn.QueryRow(context.Background(), `SELECT name FROM table WHERE id=1000`).Scan(&result) if err != nil { if err == ...

Introduction database/sql In the Go standard sql library, the *Stmt type has methods defined like: func (s *Stmt) Exec(args ...interface{}) (Result, error) func (s *Stmt) Query(args ...interface...