PostgreSQL Source
Read data from a PostgreSQL instance
Input Properties
| Property | Requirement | Type | Default | Description |
|---|---|---|---|---|
| Host | ✓ | String | - | |
| Port | ✓ | String | default | A port number or ‘default’ |
| Database | ✓ | String | - | |
| Table Name | ✓ | String | - | |
| Username | ✓ | String | - | |
| Password | ✓ | String | - | |
| Limit | Long | - | Max output count | |
| Offset | Long | - | Starting point of output | |
| Keyword Search? | Boolean | false | ||
| ↳ Keyword Search Column | String | - | ||
| ↳ Keywords to Search | String | - | E.g. ‘sore & throat’ for AND; ‘sore’, ’throat’ for OR. See official postgres documents for details | |
| Progressive? | Boolean | false | ||
| ↳ Batch by Column | String | - | ||
| ↳ Min | String | auto | ||
| ↳ Max | String | auto | ||
| ↳ Batch by Interval | Long | 1000000000 |
Output Ports
| Port | Mode |
|---|---|
| 0 | Set Snapshot |
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.