PowerCenter
- PowerCenter 10.5
- All Products
PostgreSQL
| Transformation
| Range
|
---|---|---|
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
|