Postgres Pro
Downloads
Home   >   mailing lists

Access query as executed by postgres - Mailing list pgsql-odbc

From Fred Parkinson
Subject Access query as executed by postgres
Date
Msg-id 484FB90D020000A700007EA0@groupwise.abag.ca.gov
Whole thread Raw
Responses Re: Access query as executed by postgres  ("Richard Broersma" <richard.broersma@gmail.com>)
List pgsql-odbc
Tree view 
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
promptI 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

pgsql-odbc by date:

Previous
From: "Richard Broersma"
Date:
Subject: ODBC escape convert error
Next
From: Hiroshi Inoue
Date:
Subject: Re: ODBC escape convert error