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 '
How can I assign the result of a SQL query to a variable?
The following code snippet doesn't work:
query_result=cur.execute("SELECT column_name FROM table_name WHERE
my_variable = 'my_value'",)
> Thomas Jollans wrote:
* get the record you're interested in
--
http://mail.python.org/mailman/li
Thanks a lot, this was the solution.
It would be greate, if you could also show me a way to extract the
inserted binary object from the table on the server to a file on a client.
> Peter Otten wrote:
Julia Jacobson wrote:
Hello everybody out there using python,
For the insertion of pictu
Hello everybody out there using python,
For the insertion of pictures into my PostgreSQL database [with table
foo created by SQL command "CREATE TABLE foo (bmp BYTEA)], I've written
the following script:
#!/usr/bin/python
import psycopg2
try:
conn = psycopg2.connect("dbname='postgres' use
