PostgreSQL Reader Activity

Reads PostgreSQL table as a view.

Parameters

Name	Description	Type	Default
Title	Title of the activity to display on the designer.	text
Host Name	Name or address of the server where PostgreSQL database is hosted.	text
Port	Port number which PostgreSQL database is configured with.	int	5740
Database Name	Name of the database.	text
User Name	Valid PostgreSQL user name. Consider using vault feature with templating (e.g. ${vault:secret-mydb-user})	text
Password	Password associated with above user. Consider using vault feature with templating (e.g. ${vault:secret-mydb-password})	text
Table Name	PostgreSQL table name.	text
Batch Size	Read batch size. Default value is 0 (let driver estimate best number)	int	1000
As	Name of the DataRow view linked to the PostgreSQL table.	text
Options	Additional options.	key-value