Part 2: The 32-Bit/64-Bit Drivers : The PostgreSQL Wire Protocol Driver : Data Types

Data Types
The following table shows how the PostgreSQL data types are mapped to the standard ODBC data types. Using the XML Data Type describes PostgreSQL to Unicode data type mappings.

1
Bit maps to SQL_BIT when the length for the bit is 1. If the length is greater than 1, the driver maps the column to SQL_BINARY.

2
Numeric maps to SQL_NUMERIC if the precision of the Numeric is less than or equal to 38. If the precision is greater than 38, the driver maps the column to SQL_VARCHAR.

3
Time mapping changes based on the setting of the Fetch TWFS as Time option

4
Timestamp with timezone mapping changes based on the setting of the Fetch TSWTZ as Timestamp option.

See Retrieving Data Type Information for more information about data types.
Using the XML Data Type

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.