pg

pg copied to clipboard

Will I be able to make my own Joins query and somehow go-pg can map the fields to the corresponding model? ``` err := ecrawler.DB2.Model(&products). Column("product.*"). Joins("variants on ...."). Joins("options...

sonhnguyenn

I'm having trouble getting a has one relationship to work. I followed the wiki's examples and have been trying this for hours. I know the table names and fields are...

atishpatel

Cannot call server function: pg: can't find column=xxx

1

Hello, I must be doing something silly, because I just cannot call a simple server function using go-pg. I have this server function which I call with user data, it...

howesteve

Looking for guidance on shared functionality between models

1

I would like to implement a some shared functionality across models. For example, a method that looks for one result but does not error if the one result is not...

tamoyal

can't read standard out

2

I need to execute an .sql script that raises a notice and I need to catch this text and evaluate. can pg capable of returning the standard out sql?

nicks6240

Is there a way to optimize loading large IN queries with has_many?

2

I am trying to load nested `has_many` from `products` table but it seems with large list of IDs the query generated huge IN list is not ideal. Can I do...

sonhnguyen

How to refactor this code to retrieve custom (virtual) columns from DB along with default ones with one query only

2

I'm studying Golang trying to build an application. I have written many models: - Player - Book - Score - Referee - Life - Team - Doc - Family and...

frederikhors

Is it possible to search for an element in a array

1

type User struct { ... Tags []string } Users have an array of tags, is it possible to search users based on one or multiple tags? Something similar to this:...

ncollie42

Support for binary_parameters=true

1

I am connecting to PgBouncer DB and some of the query get errors, found some fix online but apparently I need to enable `binary_parameters=true` in the URI. How do I...

sonhnguyen

Is there a way? I am having a URI like this ``` "DATABASE_URL": "postgresql://user:password@hostname:25061/dbname?sslmode=require&binary_parameters=yes", ``` I tried to used `ParseURL` but I don't think it support `binary_parameters=yes` right?

sonhnguyen