I have the generated code for the given query INSERT INTO "users" ( username, name, surname, email, hashed_password, role ) VALUES ( $1, $2, $3, $4, $5, $6 ) RETURNING "id&quo...

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...

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 have two different schemas, and I want to generate SQL that references the other schema in a JOIN statement. However, SQLC throws an error saying "schema not found." This means SQLC doe...