CODEWITHSUNDEEP
postgresqlgogo-gorm
Dinesh kumar Sivakumar
Dinesh kumar Sivakumar

Reputation: 51

How to call postgres stored procedure from golang using gorm package

I was working on a golang project, I've used a postgres database to store data with some Stored Procedure.

I used github.com/jinzhu/gorm for connecting to the database.

I used below query to retrieve data. I know in postgres we are unable to use select, so I only tried insert code in SP.

db.Database.Raw("CALL mydatabase.mystoredprocedure('" + param1 + "','" + param2 + "')")

db.Database.Raw("SELECT * FROM table1").Scan(&tableValue)

But here I'm only able to call a SELECT statement, not able to call the stored procedure.

Please, can any one help me to solve this problem?

Thanks in advance

Upvotes: 5

Views: 9739

Answers (1)

Mafor
Mafor

Reputation: 10661

db.Database.Raw(...) alone does not do anything, it needs to be chained with Scan. If you are not expecting any results, use Exec:

db.Database.Exec("CALL mydatabase.mystoredprocedure($1, $2)", param1, param2)

Upvotes: 11

Related Questions