print executed query

[Philip Semanchuk]

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