Dear python users, For passing a variable to a SQL query for psycopg2, I use:
>>> my_var = xyz>>> print cur.mogrify("SELECT my_values FROM my_table WHERE my_column = %s",(my_var,))
This returns: >>> SELECT my_values FROM my_table WHERE my_column = E'xyz'Where does the "E" in front of 'xyz' come from? It's probably the reason, why my query doesn't work.
Thanks in advance, Julia -- http://mail.python.org/mailman/listinfo/python-list
