ODBC Driver for PostgreSQL

Supported Data Types

ODBC Driver for PostgreSQL supports all the PostgreSQL data types.

The complete list of PostgreSQL data types is available in the PostgreSQL documentation.

Data Type Mapping

The following table describes how ODBC data types are mapped to PostgreSQL data types.

PostgreSQL Data Types ODBC Data Types

BIGINT

SQL_BIGINT

BIT

SQL_BIT

BYTEA

SQL_LONGVARBINARY

CHAR

SQL_WCHAR

VARCHAR

SQL_WVARCHAR

NAME

SQL_WVARCHAR

DATE

SQL_TYPE_DATE

DOUBLE

SQL_DOUBLE

REAL

SQL_REAL

TEXT

SQL_WLONGVARCHAR

NUMERIC

SQL_NUMERIC

SQL_TIME

SQL_TYPE_TIME

TIMETZ

TIMESTAMPTZ

SQL_TYPE_TIMESTAMP

SQL_INT, SQL_OID

SQL_INTEGER

UUID

SQL_GUID

© 2015-2017 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback