Table of Contents

Search

  1. Preface
  2. Introduction to PostgreSQL Connector
  3. PostgreSQL connections
  4. Mappings and mapping tasks with PostgreSQL Connector
  5. PostgreSQL objects in mapping tasks
  6. Lookup transformation
  7. SQL transformation
  8. Migrating a mapping
  9. PostgreSQL SQL ELT optimization
  10. Data type reference

PostgreSQL Connector

PostgreSQL Connector

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

0 COMMENTS

We’d like to hear from you!