0

We use psqlODBC driver through unixODBC driver to access postgres database. The unixODBC version is:

# odbcinst --version unixODBC 2.2.14

So does this mean ODBC version is v2.0?

But in psqlODBC code I see that default ODBC version set to v3.0 (i.e. 0300).

Now I am confused with these versions. Till I was assuming its v2.0. How do I know whether I am using ODBC v2.0 or v3.0?

pitnal
  • 551
  • 1
  • 5
  • 17

1 Answers1

1

You're using unixODBC version 2.2.14, using psqlODBC (unstated version) implementing the ODBC v3.0 "standard" protocol/interface.

It's like, say, Firefox version 18 using HTTP/1.1, or PgJDBC 9.4 implementing JDBC4.

Craig Ringer
  • 307,061
  • 76
  • 688
  • 778
  • Thanks for clarification. I printed the ODBC version within psqlODBC driver code and it implements ODBC v3.51. – pitnal Mar 05 '14 at 09:11