print executed query
philip at semanchuk.com
Thu Apr 29 12:49:07 EDT 2010
On Apr 29, 2010, at 12:01 PM, someone wrote:
> 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
More information about the Python-list