Search

PostgreSQL Connector

PostgreSQL Connector

Back Next

Data type reference

Data type reference

Data Integration

uses the following data types in mappings and

mapping

tasks with PostgreSQL:

PostgreSQL native data types: PostgreSQL data types appear in the source
and target
transformations when you choose to edit metadata for the fields.
Transformation data types: Set of data types that appear in the transformations. They are internal data types based on ANSI SQL-92 generic data types, which the Secure Agent uses to move data across platforms. Transformation data types appear in all transformations in a mapping.; When
Data Integration
reads source data, it converts the native data types to the comparable transformation data types before transforming the data.
When
Data Integration
writes to a target, it converts the transformation data types to the comparable native data types.

PostgreSQL and transformation data types

PostgreSQL and transformation data types supported for create target at runtime option

Rules and guidelines for data types

Watch

Comments

Cloud Connectivity Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.