ODBC Driver for PostgreSQL

Supported Data Types - ODBC Driver for PostgreSQL

Data Type Mapping

The Devart ODBC Driver for PostgreSQL supports all PostgreSQL data types.

The following table describes how the PostgreSQL data types are mapped to the ODBC 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-2022 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback