Re: Access query as executed by postgres

[aklaver(at)comcast(dot)net (Adrian Klaver)]

-------------- Original message ----------------------
From: "Fred Parkinson" <FredP(at)abag(dot)ca(dot)gov>
> When I create a query in MS Access and execute via ODBC, is there a way to tell 
> exactly what query is executed by postgres?
> 
> When I create and execute a query in Access I get what I want, but when I run 
> the same query at the pgsql command prompt I get syntax and 'function not found' 
> errors.  Clearly Access is translating my query, but into what?
> 
> I have turned ODBC logging on but it doesn't seem to log the query sent to 
> postgres.
> 
> Thanks
> 
> Fred

In postgresql.conf set:
log_statement = 'all'

This will log all statements sent to the server, assuming you have logging turned on.



--
Adrian Klaver
aklaver(at)comcast(dot)net