SQL syntax error using Python and psycopg

Question

How can you fix this SQL-code?

My Python code:

import os, pg, sys, re, psycopg2                                              

conn = psycopg2.connect("dbname=tk user=masi password=123")
cur = conn.cursor() 
cur.execute("""INSERT INTO courses ('course_nro')
    VALUES ( `:1` )""", ['hen'])

I get:

Traceback (most recent call last):                                            
  File "<stdin>", line 13, in <module>
psycopg2.ProgrammingError: syntax error at or near "'course_nro'"
LINE 1: INSERT INTO courses ('course_nro')
                             ^

did you tried with without quotes?

YOU
– YOU

2009-11-22 14:05:14 +00:00
Commented Nov 22, 2009 at 14:05 — YOU
– YOU, Commented Nov 22, 2009 at 14:05
What do you think the ^ is pointing at? hehe

Andomar
– Andomar

2009-11-22 14:09:02 +00:00
Commented Nov 22, 2009 at 14:09 — Andomar
– Andomar, Commented Nov 22, 2009 at 14:09

fog · Accepted Answer · 2009-11-30 00:17:33Z

2

You made 3 different errors in the same query:

Field names should not be quoted.
psycopg2 uses tuples, not lists for arguments.
Positional arguments like ":1" are not supported.

Change your query into:

cur.execute("""INSERT INTO courses (course_nro) VALUES (%s)""", ('hen',))

answered Nov 30, 2009 at 0:17

fog

3,4411 gold badge27 silver badges32 bronze badges

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

Comments

mthurlin · Accepted Answer · 2009-11-22 14:02:08Z

1

Remove the quotes around the fieldname:

INSERT INTO courses (course_nro)

answered Nov 22, 2009 at 14:02

mthurlin

27.4k4 gold badges43 silver badges46 bronze badges

1 Comment

bobince Over a year ago

You also need to remove the backticks around the :1 parameter.

Collectives™ on Stack Overflow

SQL syntax error using Python and psycopg

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related