PostgreSQL Connector > Data type reference > PostgreSQL and transformation data types
  

PostgreSQL and transformation data types

The following table lists the PostgreSQL data types that Data Integration supports and the corresponding transformation data types:
PostgreSQL Data Type
Transformation Data Type
Description
Smallint/Int2
Integer
Precision 10, scale 0
Int/Int4
Integer
Precision 10, scale 0
Bigint/int8
Bigint
Precision 19, scale 0
Decimal
Decimal
Precision 1 to 28, scale 0 to 28
Numeric
Decimal
Precision 1 to 28, scale 0 to 28
Real/Float4
Double
Precision 15, scale 0
Double/Float8
Double
Precision 15, scale 0
Smallserial/Int2
Integer
Precision 10, scale 0
Serial
Integer
Precision 10, scale 0
Bigserial/Serial8
BigInt
Precision 19, scale 0
Char
String
Precision 1
Char(n)
String(n)
n<=10485760
Varchar
String
Precision 104857600
Varchar(n)
String(n)
n <=10485760
Text
String
Precision 104857600
Bytea
Binary
Precision 104857600
Date
Date/Time
Precision 29, scale 9
Time
Date/Time
Precision 29, scale 9
Timestamp
Date/Time
Precision 29, scale 9
Timestamp with time zone
Date/Time
Precision 29, scale 9
Timestamp without time zone
Date/Time
Precision 29, scale 9
Boolean
String
Precision 6
Citext
Text
Precision 104857600