英文:
Postgres - Golang Error: pq: Users does not exists
问题
我正在尝试将Golang连接到一个位于Gcloud上的Postgres数据库，并且我已经允许了网络IP。我正在尝试访问User数据库，然后是public模式下的User表，这是数据库的结构：
我遇到了这个错误：pq: database "Users" does not exist
我将添加代码：
package portsimport ("database/sql""log""github.com/gofiber/fiber/v2"_ "github.com/lib/pq")func OpenConnection(dbName string) (*sql.DB, error) {connStr := "<addr>" + dbNamedb, err := sql.Open("postgres", connStr)if err != nil {log.Fatal(err)}return db, err}func GetUsers(ctx *fiber.Ctx) error {db, dbErr := OpenConnection("Users")if dbErr != nil {log.Fatalln(dbErr)}defer db.Close()rows, err := db.Query("SELECT * FROM Users")if err != nil {log.Fatalln(err)ctx.JSON("An error ocurred")}defer rows.Close()return ctx.Render("/users", fiber.Map{"Users": rows,})}
英文:
I'm trying to connect Golang to a Postgres DB, it is in Gcloud and I already allowed the network IP. I'm trying to access the User DB and then the User table inside the public schema, this is the database structure:
I am getting this error: pq: database "Users" does not exist
I'll add the code:
package portsimport ("database/sql""log""github.com/gofiber/fiber/v2"_ "github.com/lib/pq")func OpenConnection(dbName string) (*sql.DB, error) {connStr := "<addr>" + dbNamedb, err := sql.Open("postgres", connStr)if err != nil {log.Fatal(err)}return db, err}func GetUsers(ctx *fiber.Ctx) error {db, dbErr := OpenConnection("Users")if dbErr != nil {log.Fatalln(dbErr)}defer db.Close()rows, err := db.Query("SELECT * FROM Users")if err != nil {log.Fatalln(err)ctx.JSON("An error ocurred")}defer rows.Close()return ctx.Render("/users", fiber.Map{"Users": rows,})}
答案1
得分: 0
我刚刚修复了它，问题是两个方面的组合：
- 当我硬编码时，我没有正确地组合字符串，这样就解决了数据库错误。
- 之后，我遇到了一个错误，它会说表不存在，问题是我发送了一个未引用的表名，我需要它区分大小写，所以我必须用引号将名称包裹起来使其工作。像这样：
package portsimport ("database/sql""log""github.com/gofiber/fiber/v2"_ "github.com/lib/pq")func OpenConnection() (*sql.DB, error) {connStr := "<connStr>/users"db, err := sql.Open("postgres", connStr)if err != nil {log.Fatal(err)}return db, err}func GetUsers(ctx *fiber.Ctx, db *sql.DB) error {defer db.Close()rows, err := db.Query(`SELECT * FROM "Users"`)if err != nil {log.Fatalln(err)ctx.JSON("An error ocurred")}defer rows.Close()return ctx.Render("/users", fiber.Map{"Users": rows,})}
英文:
I just fixed it and it was a combination of two things:
- I wasn't properly combining the strings, when I hardcoded it I got rid of the db error.
- After that I encountered an error where it would say the table doesn't exists, the issue is I was sending an unquote table name and I needed it to be case sensitive so I had to wrap the name between quotes to make it work. Like so
package portsimport ("database/sql""log""github.com/gofiber/fiber/v2"_ "github.com/lib/pq")func OpenConnection() (*sql.DB, error) {connStr := "<connStr>/users"db, err := sql.Open("postgres", connStr)if err != nil {log.Fatal(err)}return db, err}func GetUsers(ctx *fiber.Ctx, db *sql.DB) error {defer db.Close()rows, err := db.Query(`SELECT * FROM "Users"`)if err != nil {log.Fatalln(err)ctx.JSON("An error ocurred")}defer rows.Close()return ctx.Render("/users", fiber.Map{"Users": rows,})}
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论