PostgreSQL datatypes mappings and conversions:

Design

The suggestion is to create submodule PostgreSQL under database-plugins repo.

Sink Properties

User Facing Name	Type	Description	Constraints
Label	String	Label for UI
Reference Name	String	Uniquely identified name for lineage
Host	String	PostgreSQL host	Required (defaults to localhost on UI)
Port	Number	Specific port where PostgreSQL running on	Optional (default 5432)
Database	String	Database name to connect	Required
Import Query	String	Query for import data	Valid SQL query
Username	String	DB username	Required
Password	Password	User password	Required
Bounding Query	String	Returns max and minof split-By Filed	Valid SQL query
Split-By Field Name	String	Field name which will be used to generate splits
Number of Splits to Generate	Number	Number of splits to generate
Transaction Isolation Level	Select	Transaction isolation level for queries run by this sink
Connection Arguments	Keyvalue	A list of arbitrary string tag/value pairs as connection arguments, list of properties https://jdbc.postgresql.org/documentation/head/connect.html#connection-parameters
Table Name	String	Name of a database table to write to

...