On Apr 29, 2010, at 9:49 AM, Philip Semanchuk wrote: > > On Apr 29, 2010, at 12:01 PM, someone wrote: > >> Hello! >> >> Is there a way to print a query for logging purpose as it was or will >> be sent to database, if I don't escape values of query by myself? >> >> cursor.execute(query, [id, somestring]) >> >> I could print query and values separate, but it would be great, if I >> could see how query is constructed and can the also copy it and >> execute in console. >> >> Im using psycopg2, btw > > > If you can fiddle with the Postgres server settings, the server has options > for logging lots of things, including the queries it executes. >
Yes you can fiddle like that:
>>> cur.mogrify("INSERT INTO test (num, data) VALUES (%s, %s)", (42, 'bar'))
"INSERT INTO test (num, data) VALUES (42, E'bar')"
-fred-
smime.p7s
Description: S/MIME cryptographic signature
-- http://mail.python.org/mailman/listinfo/python-list
