On May 7, 2007, at 18:17 , Rommel the iCeMAn wrote:
Is there a way that I can see
the actual SQL query that is being sent to postgresql?
From within PostgreSQL you can put the SQL queries in the logs.
http://www.postgresql.org/docs/8.2/interactive/runtime-config-
logging.html#RUNTIME-CONFIG-LOGGING-WHAT
Check out the log_statement paramenter (and possibly others).
You might also have some logging options within .NET, but as I'm
unfamiliar with the framework, I really can't help you there.
Michael Glaesemann
grzm seespotcode net
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match