Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. Datatype Reference
  17. Configure the Web Browser

PostgreSQL and Transformation Datatypes

PostgreSQL and Transformation Datatypes

The following table compares PostgreSQL datatypes to transformation datatypes:
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
Citext1
Text
Precision 104857600


Updated July 02, 2020