Chris Rebert wrote:
On Sun, Aug 29, 2010 at 11:29 PM, Julia Jacobson
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#cur
On Sun, Aug 29, 2010 at 11:29 PM, Julia Jacobson
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
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 '
