pq: syntax error at or near "$1" Postgres + go

Question

What am i doing wrong here? Tried quoting new_name also , still shows error : pq: syntax error at or near "$1" Postgres + go

func ChangeDBname(new_name string) {

oldname := "intern"
quoted := pq.QuoteIdentifier(oldname)
_, e1 := db.Exec(fmt.Sprintf("ALTER TABLE %s RENAME TO $1",quoted) , new_name)
if e1 != nil {
    fmt.Println("Eroor in change name")
    log.Fatal(e1.Error())
} else {
    fmt.Println("Table name changed to", new_name)
}

}

You cannot use parameter placeholders for identifiers. You can use them for values, but not names. You cannot for example use them for table names column names etc. — mkopriva
– mkopriva, Commented Apr 19, 2021 at 8:10

derkan · Accepted Answer · 2021-04-19 14:31:06Z

4

Table name is not a value. So PostgreSQL parser is not expecting a placeholder in this DDL.

Check this:

db.Exec(fmt.Sprintf("ALTER TABLE %s RENAME TO %s",pq.QuoteIdentifier(oldname), pq.QuoteIdentifier(new_name)))

answered Apr 19, 2021 at 14:31

derkan

4944 silver badges5 bronze badges

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

1 Comment

Captain bAri TV Over a year ago

but i want to inject the query , normal sting works

derkan · Accepted Answer · 2024-06-30 13:15:58Z

0

Do not use identifiers as params to SQL query.

Try this:

func ChangeDBname(newName string) {
    oldName := "intern"
    query := fmt.Sprintf("ALTER TABLE %s RENAME TO %s", pq.QuoteIdentifier(oldName), pq.QuoteIdentifier(newName))

    _, err := db.Exec(query)
    if err != nil {
        fmt.Println("Error in change name")
        log.Fatal(err)
    } else {
        fmt.Println("Table name changed to", newName)
    }
}

answered Jun 30, 2024 at 13:15

derkan

4944 silver badges5 bronze badges

Collectives™ on Stack Overflow

pq: syntax error at or near "$1" Postgres + go

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related