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.
Hope this helps Philip -- http://mail.python.org/mailman/listinfo/python-list