Preface
Introduction to PostgreSQL Connector
- PostgreSQL Connector assets
Connections for PostgreSQL
Mappings and mapping tasks with PostgreSQL Connector
PostgreSQL objects in mapping tasks
Lookup transformation
- Rules and guidelines for uncached lookups
SQL transformation
- Rules and guidelines for SQL transformations
Migrating a mapping
- Use the same object path for the migrated mapping
- Use a different object path for the migrated mapping
  - Migration options
  - Rules and guidelines for migrating a mapping
PostgreSQL SQL ELT optimization
Data type reference

PostgreSQL Connector

Back Next

Rules and guidelines for adding multiple source objects

Consider the following rules and guidelines when you add multiple source objects:

You cannot use a self join when you add multiple source objects.

You cannot search for a schema when you add a related source object. You must scroll down and manually select the schema.

When you select parent and child objects that have a primary key and foreign key relationship, ensure that the foreign key of the related object is not a primary key in the table.

Rename Saved Search

Table of Contents

PostgreSQL Connector

PostgreSQL Connector

Rules and guidelines for adding multiple source objects

Rules and guidelines for adding multiple source objects