You can create a mapping with a PostgreSQL source to extract data from PostgreSQL. You can create a mapping with any source and a PostgreSQL target to load data to PostgreSQL. You can use tables as PostgreSQL sources.
When the PowerCenter Integration Service extracts data from the source or loads data to the target, it converts the data based on the data types associated with the source or the target.