| Info |
|---|
This function is one of Plugins Operation.You can find the movie in ARGOS RPA+ video tutorial. |
| PostgreSQL |
|---|---|
Author Jerry ChaePrimary Features The PostgreSQL plugin enables your bot to directly connect and manipulate the Postgres database. |
Input (Required)
- DB Host Host name or IP address
- DB Port Port number
- DB Username
- DB Password
- Database Name
- SQL string or file
Advanced Input (Optional)
- CSV bulk data input
- Exclusion of # of headers
- Character set for output default is utf-8
- Encoding option for bulk CSV file input default is utf-8
- Suppress Warning
Return Value
- Return value for SQL in String, CSV, or in File
Return Code
- 0 for Success
- 99 for everything else
Parameter Setting Examples
Example SQL file
--- insert static records
INSERT INTO foo (name, age)
values
('nobody me', 100),
(‘foobar', 200)
| Tooltip | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
|
| Tooltip | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
Left Text Bubble
Right Text Bubble
|
Return Code
Code | Meaning |
|---|---|
| 0 | Execution successful |
| 1 | SQL errors |
| 9 | Other failures |