Passing variable to SQL statement when using psycopg2

Chris Rebert clp2 at rebertia.com
Mon Aug 30 09:08:58 CEST 2010


On Sun, Aug 29, 2010 at 11:29 PM, Julia Jacobson
<julia.jacobson at arcor.de> wrote:
> 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.

Quite doubtful, considering the example in the psycopg2 docs also has the E:
http://initd.org/psycopg/docs/cursor.html#cursor.mogrify

Cheers,
Chris
--
http://blog.rebertia.com



More information about the Python-list mailing list