PQ Relation does not exist when running SQL query in GoLang

Question

When running any sql query to my database in GoLang, i get the below error, does anyone know if there's anything else I can try to resolve the issue

pq: relation "users" does not exist

What I have tried:

Checked the permissions on the DB and all is okay.
Checked the credentials are okay
Ran the INSERT statement directly on the SQL database via psql
Created a minimalist program to make sure it wasn't anything else in my code
Entered values into query string manually, rather than using parameters
Tried SELECT statement and same issue. It just isn't finding the users table.
I have built the connection string through const variables, and as I have below. Neither have worked.
I have tried with, and without the port (5432)

The code below is what I have (the minimalist application outputting the same error as my main application)

func main() {
sqlInfo := fmt.Sprintf("postgres://postgres:postgres@localhost/user_details?sslmode=disable")

db, err := sql.Open("postgres", sqlInfo)
defer db.Close()

if err != nil {
    fmt.Fprintf(os.Stdout, "Connection to the database failed")
    return
}
err = db.Ping()

if err != nil {
    fmt.Fprintf(os.Stdout, "Connection to the database failed")
    return
}

fmt.Fprintf(os.Stdout, "You have connected to the database successfully")

sqlQuery := `INSERT INTO users ("user_id", "username", "password", "email", "gender", "gang") VALUES ($1, $2, $3, $4, $5, $6)`
_, err = db.Exec(sqlQuery, 1, "Ross8839", "rocky8839", "[email protected]", "Female", "Greengos")
if err != nil {
    fmt.Fprintf(os.Stdout, "Failed to query db")
    panic(err)
}
}

I expect that the above code isn't incorrect, as I had this working in my windows environment, but I don't want to use windows for development. This is all in my Linux environment, and since moving over... I have encountered this issue.

Below are the permissions for postgres user on database

https://i.sstatic.net/SQJ5n.png

I actually feed stupid. I think you're right. I created the database, and just assumed that I was creating the tables within the database. That's not what happened, and you're right. Thank you for your help. If you can answer the question, I will select it — Ross Bown
– Ross Bown, Commented Feb 8, 2019 at 19:44

mu is too short · Accepted Answer · 2019-02-09 03:05:07Z

11

Your connection string:

postgres://postgres:postgres@localhost/user_details?sslmode=disable

says that you're connecting to the user_details database. Perhaps you created the users table in a different database.

answered Feb 9, 2019 at 3:05

mu is too short

436k71 gold badges863 silver badges822 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Narendra Kamath · Accepted Answer · 2019-02-09 04:26:31Z

0

Your code seems to have no issue and seems to be a working one. I highly doubt if the table users is actually present in the selected database user_details.

answered Feb 9, 2019 at 4:26

Narendra Kamath

591 silver badge6 bronze badges

Collectives™ on Stack Overflow

PQ Relation does not exist when running SQL query in GoLang

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related