Psycopg2 issue inserting values into an existing table in the database

Question

I am having a hard time understanding why psycopg2 has a problem with the word 'user'. I am trying to insert values into a table called user with the columns user_id, name, password. I am getting a programmingError: syntax error at or near "user". open_cursor() is a function used to open a cursor for database operations.

Here is my code:

query = """INSERT INTO user (name, password) VALUES (%s, %s);"""
data = ('psycouser', 'sha1$ba316b$52dd71da1e331247f0a7ab869e1b072210add9c1')
with open_cursor() as cursor:
    cursor.execute(query, data)
    print "Done."

Please always quote table names.

frlan
– frlan

2016-11-23 16:08:53 +00:00
Commented Nov 23, 2016 at 16:08 — frlan
– frlan, Commented Nov 23, 2016 at 16:08

Vao Tsun · Accepted Answer · 2016-11-23 16:06:47Z

4

because user is a part of sql language.

try taking it in dbl quotes:

query = 'INSERT INTO "user" (name, password) VALUES (%s, %s);'

answered Nov 23, 2016 at 16:06

Vao Tsun

52.4k13 gold badges114 silver badges149 bronze badges

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

Collectives™ on Stack Overflow

Psycopg2 issue inserting values into an existing table in the database

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related