ODBC Specification Supported
ODBC (Open Database Connectivity) is a standard API originally developed by Microsoft for accessing database management systems (DBMS). The standard has evolved over the years. The PSQL Relational Interface supports the ODBC v3.51 specifications for Core, Level 1, and Level 2 interface support levels (Level 3 is not supported).
Exceptions to ODBC Interface Support
Core Level
SQL_BEST_ROWID
The Relational Interface uses unique indexes as the optimal set of columns that identifies a row in the table.
When a new row is inserted into a table that includes an IDENTITY column, the Relational Interface does not return the value assigned to the IDENTITY column. You may determine the value for an IDENTITY column through the use of the @@IDENTITY variable. See
@@IDENTITY
in
SQL Engine Reference
.
Level 2
The following are not supported:
•
SQL_ATTR_LOGIN_TIMEOUT
•
SQL_BEST_ROWID (see discussion above)
•
SQL_ROWVER