You can use a PostgreSQL object as a source in a data loader task.
When you create a data loader task to read data from PostgreSQL, specify the PostgreSQL source properties.
The following table describes the PostgreSQL source properties:
Property
Description
Connection
Name of the source connection.
Select a source connection or create a new connection.
Source Path
The path to the directory that contains the source data.
The path is populated from the schema connection property but you can edit the path.
Rules and guidelines for primary key fields and watermark fields
When you read data from PostgreSQL, the primary key fields are detected. You can manually define the primary key fields and watermark fields. The default values are Automatically detect from source and Watermark fields not required.