psycopg2.ProgrammingError: syntax error at or near "OR

Question

I am using python 2.7 and postgresql 9.3 with psycopg2 2.7.3, when I try to execute a select query while parameter passing it gives me this error psycopg2.ProgrammingError: syntax error at or near "OR

cur = con.cursor()
cur.execute('SELECT * FROM test WHERE voucher= ? OR voucher= ?', ('RHAT', 'MSO'))

the error message is

psycopg2.ProgrammingError: syntax error at or near "OR"

Martijn Pieters · Accepted Answer · 2017-10-01 10:55:45Z

5

Psycopg2 uses %s placeholders, not ? questionmarks:

cur.execute(
    'SELECT * FROM test WHERE voucher = %s OR voucher = %s',
    ('RHAT', 'MSO'))

See the Passing parameters to SQL queries section of the Psycopg2 documentation.

Python database adapters generally stick with one or the other style (with accompanying named parameter styles). Always check the documentation to see what style is used. There is a paramstyle variable on the library, but that doesn't always reflect support for multiple styles very well.

edited Oct 1, 2017 at 10:55

answered Oct 1, 2017 at 10:50

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

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

3 Comments

Sameesh Over a year ago

When I trying to pass table name into a query it dosn't seem to work cur.execute('DROP TABLE %s ;', ('test',))

Martijn Pieters Over a year ago

@Sameesh: a table name is not data, no. A placeholder escapes data specifically to not be mistaken for SQL instructions or object names.

Martijn Pieters Over a year ago

See Pass column name as parameter to PostgreSQL using psycopg2 for a method to include a tablename.

Collectives™ on Stack Overflow

psycopg2.ProgrammingError: syntax error at or near "OR

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related