print executed query

Philip Semanchuk philip at
Thu Apr 29 12:49:07 EDT 2010

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

More information about the Python-list mailing list